I belive a lock is acquired on every table including inherited children
BEFORE doing ANY dumping. To allow pg_dump to get a consistent dump
snapshot.
Chris
Yann Michel wrote:
Hi,
On Wed, Nov 16, 2005 at 09:59:44AM +0800, Christopher Kings-Lynne wrote:
It acquires share locks on EVERY table.
do you mean on EVERY inherited table once one of them is dumped? Or do
you mean that a share lock is requested(and hold) on each of them once
one is dumped, i.e., sequentially?
Thanks,
Yann
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
