On Thu, Nov 03, 2005 at 07:40:15PM -0000, Andrew - Supernews wrote: > On 2005-11-03, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > Peter Eisentraut wrote: > >> Someone wanted to rename a database while someone else was running a > >> rather long pg_dump, so the rename had to wait, and everyone else had > >> to wait for the rename because no new connections would be allowed. > > > > As an auxiliary issue, why do the new connections have to wait in this > > case? The rename waits for the AccessShareLock of the dump to be > > released, but meanwhile new connections should be able to get > > AccessShareLocks of their own. > > No. New AccessShare locks block behind the pending AccessExclusive lock. > Otherwise AccessShare locks could starve the exclusive lock forever.
I would argue that in cases like this (and 'this' means just about any DDL, for starters) that it would be better not to block everyone until work can actually be done. Or at least make that an option. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
