Thread: Analyze during a transaction

Analyze during a transaction

From
bobJobS
Date:
I am running Postgres 9.3 on RedHat Linux 5.6.

During the transaction data is deleted from our database, then an analyze is
performed.

If I analyze our database during a transaction and the transaction fails
(rollback occurs), with the table statistics rollback to their original
values?



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Analyze-during-a-transaction-tp5775069.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: Analyze during a transaction

From
Peter Eisentraut
Date:
On 10/18/13 12:28 PM, bobJobS wrote:
> If I analyze our database during a transaction and the transaction fails
> (rollback occurs), with the table statistics rollback to their original
> values?

Yes.

ANALYZE isn't really that special.  It reads data from some tables, does
some math on it, and writes the results to other tables (pg_statistic).
 All of that is subject to transaction semantics.