[Pgpool-general] Problem/question...

[Tatsuo Ishii]

> 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