Search Postgresql Archives

Re: Do I need to COMMIT an analyze statement?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Do I need to COMMIT an analyze statement?
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Fri, 31 Mar 2017 07:49:19 -0700
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <oblgvj$fac$1@blaine.gmane.org>
References: <oblgvj$fac$1@blaine.gmane.org>

On Friday, March 31, 2017, Thomas Kellerer <spam_eater@xxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Do I need to COMMIT an analyze statement?
  - From: Thomas Kellerer

References:
- Do I need to COMMIT an analyze statement?
  - From: Thomas Kellerer

Prev by Date: Re: Debian Bug#859033: pg_dump: creates dumps that cannot be restored
Next by Date: Re: Re: Debian Bug#859033: pg_dump: creates dumps that cannot be restored
Previous by thread: Do I need to COMMIT an analyze statement?
Next by thread: Re: Do I need to COMMIT an analyze statement?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux