[Pgpool-committers] pgpool - pgpool-II: When insert_lock is enabled and the table includes

User T-ishii t-ishii at pgfoundry.org
Thu Aug 19 09:25:40 UTC 2010


Log Message:
-----------
When insert_lock is enabled and the table includes SERIAL data type,
issue row lock on the sequence table. Before we issues table
lock. Problem is, the table lock conflicts with auto vacuum and
sometimes caused excessive lock waiting.

Remove unnused global variable start_internal_transaction

Remove #ifdef out comments in pool_session_context.h

Modified Files:
--------------
    pgpool-II:
        NEWS (r1.36 -> r1.37)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/NEWS?r1=1.36&r2=1.37)
        pool_process_query.c (r1.243 -> r1.244)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_process_query.c?r1=1.243&r2=1.244)
        pool_proto_modules.c (r1.81 -> r1.82)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_proto_modules.c?r1=1.81&r2=1.82)
        pool_proto_modules.h (r1.21 -> r1.22)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_proto_modules.h?r1=1.21&r2=1.22)
        pool_relcache.c (r1.10 -> r1.11)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_relcache.c?r1=1.10&r2=1.11)
        pool_relcache.h (r1.2 -> r1.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_relcache.h?r1=1.2&r2=1.3)
        pool_session_context.h (r1.18 -> r1.19)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_session_context.h?r1=1.18&r2=1.19)
    pgpool-II/doc:
        pgpool-ja.html (r1.107 -> r1.108)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/doc/pgpool-ja.html?r1=1.107&r2=1.108)


More information about the Pgpool-committers mailing list