[Pgpool-general] General pgpool locking issues

[Yoshiyuki Asaba]

Hi,

From: "John Black" <tgh003 at gmail.com>
Subject: [Pgpool-general] General pgpool locking issues
Date: Sun, 30 Jul 2006 10:51:32 -0700

> We have been testing with pgpool for a little while here and have run into
> various locking (or lack there of) issues.
> 
> Our setup is 2 databases (pg v8.1.4) on seperate machines with all db
> connections connected via pgpool.  We have run into situations where we the
> 1st or 2nd database was not getting the update or insert fast enough, and a
> select query hitting pgpool at the same time causing the a "mismatch" error
> causing pgpool to degrade and stop replicating.

Which pgpool version do you use?


> Although I assume this must be quite a normal issue, I do not see many
> people talking about it here.
> 
> Can someone give me a basic rundown of the "best practices" for pg locking
> on a pretty database intensive web app?

I recommend that you set replication_strict to true in pgpool.conf.
And if you use SERIAL data type, you should set insert_lock to true. 

--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp