Re: Analyze during a transaction

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: bobJobS <russelljanusz(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Analyze during a transaction
Date: 2013-10-18 18:48:36
Message-ID: 52618284.6090909@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Jelinek 2013-10-18 19:00:36 Re: Bug? Function with side effects not evaluated in CTE
Previous Message Rémi Cura 2013-10-18 17:50:32 Re: Cannot import logs from csv