| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Transactions, stats and analyze (oh-my) |
| Date: | 2016-02-16 21:32:53 |
| Message-ID: | 18549.1455658373@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Steve Crawford <scrawford(at)pinpointresearch(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-02-17 05:11:48 | Re: pgDay Asia / talks / lightning talks |
| Previous Message | Steve Crawford | 2016-02-16 21:26:28 | Transactions, stats and analyze (oh-my) |