Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory - Mailing list pgsql-general

From Tom Lane
Subject Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Date
Msg-id 20761.1399902121@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory  (Souquieres Adam <adam.souquieres@axege.com>)
Responses Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Souquieres Adam
Date:
Subject: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Next
From: Souquieres Adam
Date:
Subject: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory