Re: [PERFORM] Is ANALYZE transactional?

2007-11-05 Thread Tom Lane
Craig James <[EMAIL PROTECTED]> writes: > 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.) Yes --- ANALYZE doesn't do an

[PERFORM] Is ANALYZE transactional?

2007-11-05 Thread Craig James
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 ---(end of broadcast)-