On Sun, Dec 21, 2008 at 12:18 AM, Tatsuo Ishii <[email protected]> wrote:

> I have committed changes to automatically detect if SERIAL data type
> is used or not. If used(checking the system catalog in master), the
> table is automatically locked while inserting data if insert_lock is
> specified.

Nice work, Tatsuo. Thanks a lot for your time on the project!

> Until now, if insert_lock is specified, the table is locked
> unconditionaly while inserting data, which causes unnecssary locks
> thus leads to performance loss.

Not my case, but I was wondering what if the reason was stuff such as
CURRENT_TIMESTAMP and those type of functions...

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to