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.