Postgres Pro
Downloads
Home   >   mailing lists

Re: Do I need to COMMIT an analyze statement? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Do I need to COMMIT an analyze statement?
Date
Msg-id CAKFQuwbHck1vP2ZSWDdQOBHW9=pCiMAPJMRTLL376VWa7SGtbA@mail.gmail.com
Whole thread Raw
In response to Do I need to COMMIT an analyze statement?  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Do I need to COMMIT an analyze statement?
List pgsql-general
Tree view
On Friday, March 31, 2017, Thomas Kellerer <spam_eater@gmx.net> wrote:
Hello,

something I have always wondered:

If I run with autocommit turned OFF, do I need to commit an ANALYZE statement, or is that "non-transactional"?


The results are stored in a catalog table so they are transactional.

David J. 

pgsql-general by date:

Previous
From: Thorsten Glaser
Date:
Subject: Re: Debian Bug#859033: pg_dump: creates dumps that cannot berestored
Next
From: Adrian Klaver
Date:
Subject: Re: Re: Debian Bug#859033: pg_dump: creates dumps thatcannot be restored