[Pgpool-general] Problem/question...

[Albert Gabàs | Astabis]

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