[Pgpool-general] Problem/question...

[Tatsuo Ishii]

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
> lopd at astabis.com
> 
> 
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general