Unless you have those queries in reset_query_list, there's no possibilty for pgpool to send such queries.
It seems you have a back door on backend1. I recommend you to enaale log_connections to see who is sending the query. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > I have pgpool configured to write to two backends and read from one backend: > > > # 1st backend > backend_hostname0 = '192.168.15.101' > backend_port0 = 5432 > backend_weight0 = 1 > backend_data_directory0 = '/var/lib/postgresql/8.3/main' > > > # 2nd backend - we only write to it (it has weight 0); unless the local one > crashed > backend_hostname1 = '192.168.15.201' > backend_port1 = 5432 > backend_weight1 = 0 > backend_data_directory1 = '/var/lib/postgresql/8.3/main' > > > > Both PostgreSQL servers use the same configuration (identical postgresql.conf > files). > > > However, as I test it and analyze the logs, I see backend0 gets around 30 > queries per hour (which is more or less the number of queries I do). > > On the other hand, backend1 gets literally _tens of thousands_ of queries > from pgpool, and it's not anything I ask the server. They look like below: > > [383-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.055 ms statement: SHOW > client_encoding > [384-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.050 ms statement: SHOW > default_transaction_isolation > [385-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.043 ms statement: BEGIN; > SET TRANSACTION ISOLATION LEVEL READ COMMITTED > [386-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.034 ms statement: SET TIME > ZONE E'Asia/Singapore' > [387-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.035 ms statement: ROLLBACK > [388-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.023 ms statement: BEGIN > [389-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.032 ms statement: RESET > ALL > [390-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.026 ms statement: COMMIT > [391-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.024 ms statement: BEGIN > [392-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.036 ms statement: SET > SESSION AUTHORIZATION DEFAULT > [393-1] 2010-03-01 03:06:56 SGT LOG: duration: 0.028 ms statement: COMMIT > > > And they are repeated every second or so. > > Does anyone have an idea why pgpool queries one of the backends so often? > The queries I made by pgpool, as they stop when I stop pgpool. > > I use pgpool-2.3.2.2, but I had this also with pgpool 2.3.1. > > > -- > Tomasz Chmielewski > http://wpkg.org > _______________________________________________ > 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
