Souquieres Adam <adam(dot)souquieres(at)axege(dot)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