Search Postgresql Archives

Do I need to COMMIT an analyze statement?

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

Subject: Do I need to COMMIT an analyze statement?
From: Thomas Kellerer <spam_eater@xxxxxxx>
Date: Fri, 31 Mar 2017 14:10:34 +0200
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666

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"?

Thomas



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Follow-Ups:
- Re: Do I need to COMMIT an analyze statement?
  - From: David G. Johnston

Prev by Date: Re: PostgreSQL and Kubernetes
Next by Date: Re: [HACKERS] REFERENCES privilege should not be symmetric (was Re: Postgres Permissions Article)
Previous by thread: pg_dump recording privileges on foreign data wrappers
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