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 -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org
signature.asc
Description: OpenPGP digital signature