Thread: Analyze during a transaction
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.
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.