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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Souquieres Adam <adam(dot)souquieres(at)axege(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Merlin Moncure <mmoncure(at)gmail(dot)com>
Subject: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Date: 2014-05-12 13:42:01
Message-ID: 20761.1399902121@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Souquieres Adam 2014-05-12 13:43:12 Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Previous Message Souquieres Adam 2014-05-12 13:33:26 Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory