Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory

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@axege.com> 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
>
>