pgsql: During pg_dump startup, acquire table locks in batches. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: During pg_dump startup, acquire table locks in batches.
Date
Msg-id E1pCqDI-001uNY-Cy@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
During pg_dump startup, acquire table locks in batches.

Combine multiple LOCK TABLE commands to reduce the number of
round trips to the server.  This is particularly helpful when
dumping from a remote server, but it seems useful even without
that.  In particular, shortening the time from seeing a table
in pg_class to acquiring lock on it reduces the window for
trouble from concurrent DDL.

Aleksander Alekseev, reviewed by Fabrízio de Royes Mello,
Gilles Darold, and Andres Freund

Discussion: https://postgr.es/m/CAJ7c6TO4z1+OBa-R+fC8FnaUgbEWJUf2Kq=nRngTW5EXtKru2g@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5f53b42cfd053a724fcbe0712a9d5716e576a3e6

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 36 +++++++++++++++++++++++++++++++-----
1 file changed, 31 insertions(+), 5 deletions(-)


pgsql-committers by date:

Previous
From: David Rowley
Date:
Subject: pgsql: Fix typo in memutils_memorychunk.h
Next
From: Peter Geoghegan
Date:
Subject: pgsql: Update obsolete multixact.c comments.