Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxx 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
