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
