Re: VACUUM ANALYZE Issues

From: Andres Freund <andres(at)anarazel(dot)de>
To: Harold Falkmeyer <hfalkmeyer(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE Issues
Date: 2017-06-09 05:25:10
Message-ID: 20170609052510.evu73vqxam6kwpzz@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2017-06-09 13:36:07 SSL certificate revocation file will not load
Previous Message Harold Falkmeyer 2017-06-09 04:52:38 Re: VACUUM ANALYZE Issues