pgpool-II 4.7.0 Documentation
Prev | Up | Chapter 2. Installation of Pgpool-II | Next

# 2.8. Creating insert_lock table

If you are not going to use the native replication mode nor snapshot isolation mode, you can skip this section.

If you plan to use the native replication mode or snapshot isolation mode and insert_lock, creating `pgpool_catalog.insert_lock` table for mutual exclusion is strongly recommended. Without this, insert_lock works so far. However in that case Pgpool-II locks against the insert target table. This behavior is same table lock conflicts with `VACUUM`, so `INSERT` processing may be thereby kept waiting for a long time.

    $ cd pgpool-II-4.7.0/src/sql
    $ psql -f insert_lock.sql template1

Executing `insert_lock.sql` should be performed on every databases accessed via Pgpool-II. You do not need to do this for a database created after the execution of `psql -f insert_lock.sql template1`, as this template database will be cloned to create new databases.

Prev | Home | Next
Installing pgpool-regclass | Up | Compiling and installing documents