Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] VACUUM ANALYZE Issues - Mailing list pgsql-admin

From Andres Freund
Subject Re: [ADMIN] VACUUM ANALYZE Issues
Date
Msg-id 20170609052510.evu73vqxam6kwpzz@alap3.anarazel.de
Whole thread Raw
In response to Re: [ADMIN] VACUUM ANALYZE Issues  (Harold Falkmeyer <hfalkmeyer@gmail.com>)
Responses Re: [ADMIN] VACUUM ANALYZE Issues  (Harold Falkmeyer <hfalkmeyer@gmail.com>)
List pgsql-admin
Tree view 
Hi,

Please don't full-quote on this list.

On 2017-06-08 21:52:38 -0700, Harold Falkmeyer wrote:
> What would cause a VACUUM ANALYZE to acquire an ACCESS EXCLUSIVE lock (not
> running as a VACUUM FULL)?

It does so when truncating the relation, to remove free space at the end
of the relation. If there's a lot of free space, that can take a while.
This has been much improved in releases since 8.4...

- Andres

pgsql-admin by date:

Previous
From: Harold Falkmeyer
Date:
Subject: Re: [ADMIN] VACUUM ANALYZE Issues
Next
From: John Scalia
Date:
Subject: [ADMIN] SSL certificate revocation file will not load