Postgres Pro
Downloads
Home   >   mailing lists

pgsql-server: Fallout from changing index locking rules: we can reduce - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql-server: Fallout from changing index locking rules: we can reduce
Date
Msg-id 20041001171152.8E05E32A032@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Fallout from changing index locking rules: we can reduce the strength
of locking used by REINDEX.  REINDEX needs only ShareLock on the parent
table, same as CREATE INDEX, plus an exclusive lock on the specific index
being processed.

Modified Files:
--------------
    pgsql-server/src/backend/catalog:
        index.c (r1.239 -> r1.240)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/catalog/index.c.diff?r1=1.239&r2=1.240)
    pgsql-server/src/backend/optimizer/util:
        plancat.c (r1.96 -> r1.97)

(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/optimizer/util/plancat.c.diff?r1=1.96&r2=1.97)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server: Code review for NOWAIT patch: downgrade NOWAIT from fully
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server: Don't assume PQdb() will return a valid result from a