Hi, Tom,

Tom Lane wrote:
> We could add another LockTagType just for ANALYZE, but that seems like
> rather a lot of infrastructure to support an extremely narrow corner
> case, namely two people doing database-wide ANALYZE at the same time
> inside transaction blocks.  (If they do it outside a transaction block
> then the ANALYZE is divided into multiple xacts and so doesn't try to
> hold locks on multiple tables concurrently.  autovacuum won't try to do
> that either.) 

Is there any reason to allow ANALYZE run insinde a transaction at all?

Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to