pg_dump LOCK TABLE ONLY question - Mailing list pgsql-hackers

From Filip Rembiałkowski
Subject pg_dump LOCK TABLE ONLY question
Date
Msg-id CAP_rww=n_v48D0Q97MfNzCQj=iWJKXKT82OEVdz3gBE7HRFCSQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump LOCK TABLE ONLY question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi.

I'm running pg_dump constrained to one schema. It appears that pg_dump runs

"LOCK TABLE %s IN ACCESS SHARE MODE" for each table.

Naturally it makes sense, but...

This schema has a table that serves as parent for thousands of child
tables (via INHERITS).

So effectively, to dump this schema, I have to LOCK all these tables
not only parent.

pg_dump does it automatically, I checked in current trunk - it does
not add ONLY keyword. Should it?

I wonder if it it counts as a bug.
If not a bug, maybe it counts as a feature request?

Thanks.



pgsql-hackers by date:

Previous
From: "Jinyu Zhang"
Date:
Subject: Patch: Optimize memory allocation in function 'bringetbitmap'
Next
From: David Rowley
Date:
Subject: Re: PATCH: use foreign keys to improve join estimates v1