Re: pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Reduce lock levels for ALTER TABLE SET autovacuum storage option
Date: 2015-08-15 12:17:34
Message-ID: CAB7nPqTgVWdCpt5WTHpaJVVdC9dtiU4_xwdYFgUQcPNwufOqQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Fri, Aug 14, 2015 at 10:20 PM, Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2015-08-15 14:32:13 pgsql: Use the correct type for TableInfo->relreplident.
Previous Message Robert Haas 2015-08-15 03:13:32 pgsql: Remove unused expected-output file.