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
