[Pgpool-general] Problem/question...

[Albert Gabàs | Astabis]

Dear Tatsuo,
Thank you for your quick answer.

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??

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


-----Mensaje original-----
De: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
Enviado el: miércoles, 28 de octubre de 2009 10:31
Para: agabas at astabis.com
CC: pgpool-general at pgfoundry.org
Asunto: Re: [Pgpool-general] Problem/question...

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