I just hit the 20k locks in pg_locks, on 18k differents relations owned
by the same virtual transaction and PID.
I only have like 500 tables and like 2k indexes, i must miss something.
Le 12/05/2014 15:42, Tom Lane a écrit :
Souquieres Adam <adam.souquieres@xxxxxxxxx> writes:
ANALYSE VERBOSE; should use only one transaction or one transaction per
table it analyse ?
ANALYZE is just a simple statement: it doesn't start or stop any
transactions. So all the locks will be acquired in the calling
transaction.
You might be better off using VACUUM ANALYZE, which although it
does more work will divide the work into a transaction per table.
regards, tom lane
