I suspect the difference comes from the network connection between pgpool and master vs. pgpool and 188.40.X.X.
What about trying: - run psql on master and connect to master - run psql on master and connect to 188.40.X.X. Do you see query speed difference? -- Tatsuo Ishii SRA OSS, Inc. Japan > Hello, > I have a problem/question: > > When the backend1 is disabled, the "select" queries to the backend0 are very > very fast. However, when I enable the backend1, the queries are very very > slow queries. > > Why the "select" queries becomes a very slow queries if the queries should > to go only to the backend0? > > replication_mode = true > load_balance_mode = false > replication_stop_on_mismatch = true > replicate_select = false > > backend_hostname0 = '127.0.0.1' > backend_port0 = 65432 > backend_weight0 = 1 > #backend_hostname1 = '188.40.X.X' > #backend_port1 = 65432 > #backend_weight1 = 0 > > Regards > -- > Albert Gabàs - Astabis > Information Risk Management > > Movil: +34 687 733 222 | Oficina: +34 932 417 962 > Fax: +34 932 400 545 > SkypeID: albert.gabas > > > > Le informamos que los datos personales que facilite/ha facilitado pasarán a > formar parte de un fichero responsabilidad de ASTABIS IRM, S.L. y que tiene > por finalidad gestionar las relaciones con usted. Tiene derecho al acceso, > rectificación cancelación y oposición en nuestro domicilio social sito en la > calle Balmes, 297 1º 2ª de Barcelona o a la dirección de e-mail > [email protected] > > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
