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