> Yes, there are a query speed difference due to network connection, > but with pgpool, the speed difference increase is 5x times. > > I did think that the "select" queries run fast to the master and the > "insert" queries run more slow due to replication. > "insert" slow queries not is a problem, but why the master need to connect > to the backend1 (144.40.X.X) and slow the select queries, if the > load_balance_mode is false??
With load_balance_mode is false, all SELECTs should be sent to master only. What is your SELECT query being sent to both master and backend1 exactly? -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
