On Mon, Aug 09, 2004 at 04:44:58PM +0800, Christopher Kings-Lynne wrote: > I read this in the release notes: > > --- > # Database-wide ANALYZE does not hold locks across tables (Tom) > > This reduces the potential for deadlocks against other backends that > want exclusive locks on tables. To get the benefit of this change, do > not execute database-wide ANALYZE inside a transaction block (BEGIN > block); it must be able to commit and start a new transaction for each > table. > --- > > Does that mean that now if we used savepoints internally, analyze can > still be run in a transaction and still not hold lots of locks?
No, because savepoints do not release locks on successful completion, only on rollback. I think both VACUUM and ANALYZE could be best served by appropiate use of short-lived ResourceOwners. It needs some thought though. -- Alvaro Herrera (<[EMAIL PROTECTED]>) "El realista sabe lo que quiere; el idealista quiere lo que sabe" (Anónimo) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
