Re: Transactions, stats and analyze (oh-my)

Steve Crawford <scrawford@pinpointresearch.com> writes:
> I would like to roll a number of steps into a transaction. What happens to
> the stats data generated by ANALYZE if the transaction is rolled back?

> This message says the stats are reverted:
> http://postgresql.nabble.com/Analyze-during-a-transaction-td5775069.html

That's correct.  They're just rows in a table, same as any other database
data.

> This implies they are not:
> http://www.postgresql.org/message-id/E1XjbTw-0002f9-Ri@gemulon.postgresql.org

That's about data in the pg_class row, which is a different thing from
the pg_statistic data that you're worried about.

            regards, tom lane