[Pgpool-general] pgpool hangs when set insert_lock false

Tatsuo Ishii ishii at sraoss.co.jp
Fri Jan 21 07:14:15 UTC 2011


> I'm using pgbench to benchmark the pgpool. In order to avoid table
> lock, I tried to set insert_lock as false, but it caused pgpool hang.
> If I set insert_lock back to true, it works fine.
> 
> Do we have to set insert_lock true? Any suggestions?

Can you show us pgpool version, pgbench arguments, pgpool.conf and
postgresql.conf?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the Pgpool-general mailing list