Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option - Mailing list pgsql-committers

From Michael Paquier
Subject Re: pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option
Date
Msg-id CAB7nPqTgVWdCpt5WTHpaJVVdC9dtiU4_xwdYFgUQcPNwufOqQA@mail.gmail.com
Whole thread Raw
In response to pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-committers
Tree view 
On Fri, Aug 14, 2015 at 10:20 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Reduce lock levels for ALTER TABLE SET autovacuum storage options
>
> Reduce lock levels down to ShareUpdateExclusiveLock for all autovacuum-related
> relation options when setting them using ALTER TABLE.
>
> Add infrastructure to allow varying lock levels for relation options in later
> patches. Setting multiple options together uses the highest lock level required
> for any option. Works for both main and toast tables.

Thanks for the last push!
--
Michael

pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Remove unused expected-output file.
Next
From: Andres Freund
Date:
Subject: pgsql: Use the correct type for TableInfo->relreplident.