Postgres Pro
Downloads
Home   >   mailing lists

Re: Analyze during a transaction - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Analyze during a transaction
Date
Msg-id 52618284.6090909@gmx.net
Whole thread Raw
In response to Analyze during a transaction  (bobJobS <russelljanusz@yahoo.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Rémi Cura
Date:
Subject: Re: Cannot import logs from csv
Next
From: Adam Jelinek
Date:
Subject: Re: Bug? Function with side effects not evaluated in CTE