Postgres Pro
Downloads
Home   >   mailing lists

Is ANALYZE transactional? - Mailing list pgsql-performance

From Craig James
Subject Is ANALYZE transactional?
Date
Msg-id 472FF7C5.2060402@emolecules.com
Whole thread Raw
In response to Re: Which index methodology is better?-  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Is ANALYZE transactional?
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Database connections and stored procs (functions)
Next
From: Tom Lane
Date:
Subject: Re: Is ANALYZE transactional?