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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
