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 [email protected] -----Mensaje original----- De: Tatsuo Ishii [mailto:[email protected]] Enviado el: miércoles, 28 de octubre de 2009 10:31 Para: [email protected] CC: [email protected] 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 > [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
