Is ANALYZE transactional?

From: Craig James <craig_james(at)emolecules(dot)com>
To: PGSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Is ANALYZE transactional?
Date: 2007-11-06 05:12:37
Message-ID: 472FF7C5.2060402@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

If I do:

begin;
update some_table set foo = newvalue where a_bunch_of_rows_are_changed;
analyze some_table;
rollback;

does it roll back the statistics? (I think the answer is yes, but I need to be sure.)

Thanks,
Craig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-11-06 05:30:34 Re: Is ANALYZE transactional?
Previous Message Merlin Moncure 2007-11-06 02:47:02 Re: Database connections and stored procs (functions)