pgsql: Adjust scan plan nodes to avoid getting an extra AccessShareLock

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Adjust scan plan nodes to avoid getting an extra AccessShareLock
Date: 2005-12-02 20:03:42
Message-ID: 20051202200342.EA3D79DCF92@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Adjust scan plan nodes to avoid getting an extra AccessShareLock on a
relation if it's already been locked by execMain.c as either a result
relation or a FOR UPDATE/SHARE relation. This avoids an extra trip to
the shared lock manager state. Per my suggestion yesterday.

Modified Files:
--------------
pgsql/src/backend/executor:
execMain.c (r1.261 -> r1.262)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c.diff?r1=1.261&r2=1.262)
execUtils.c (r1.129 -> r1.130)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execUtils.c.diff?r1=1.129&r2=1.130)
nodeBitmapHeapscan.c (r1.7 -> r1.8)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeBitmapHeapscan.c.diff?r1=1.7&r2=1.8)
nodeBitmapIndexscan.c (r1.12 -> r1.13)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeBitmapIndexscan.c.diff?r1=1.12&r2=1.13)
nodeIndexscan.c (r1.107 -> r1.108)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeIndexscan.c.diff?r1=1.107&r2=1.108)
nodeSeqscan.c (r1.55 -> r1.56)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeSeqscan.c.diff?r1=1.55&r2=1.56)
nodeTidscan.c (r1.45 -> r1.46)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeTidscan.c.diff?r1=1.45&r2=1.46)
pgsql/src/include/executor:
executor.h (r1.121 -> r1.122)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/executor.h.diff?r1=1.121&r2=1.122)
pgsql/src/include/nodes:
execnodes.h (r1.145 -> r1.146)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h.diff?r1=1.145&r2=1.146)

Browse pgsql-committers by date

  From Date Subject
Next Message User Dpage 2005-12-02 20:18:17 psqlodbc - psqlodbc: Make sure data_at_exec parameters are cleared by
Previous Message Bruce Momjian 2005-12-02 17:39:44 pgsql: Remove idea of increasing NUMERIC length: < * Change NUMERIC to