Re: [HACKERS] Reduce lock levels others reloptions in ALTER TABLE

2016-03-10 Thread Simon Riggs
On 1 March 2016 at 19:00, Robert Haas wrote: > On Mon, Feb 29, 2016 at 12:58 PM, Fabrízio de Royes Mello > wrote: > > Some time ago we added [1] the infrastructure to allow different lock > levels > > for relation options. > > > > So per discussion [2] the attached patch reduce lock levels down

Re: [HACKERS] Reduce lock levels others reloptions in ALTER TABLE

2016-03-01 Thread Robert Haas
On Mon, Feb 29, 2016 at 12:58 PM, Fabrízio de Royes Mello wrote: > Some time ago we added [1] the infrastructure to allow different lock levels > for relation options. > > So per discussion [2] the attached patch reduce lock levels down to > ShareUpdateExclusiveLock for: > - fastupdate > - fillfac

Re: [HACKERS] Reduce lock levels others reloptions in ALTER TABLE

2016-02-29 Thread Fabrízio de Royes Mello
On Mon, Feb 29, 2016 at 2:58 PM, Fabrízio de Royes Mello < fabriziome...@gmail.com> wrote: > > Hi all, > > Some time ago we added [1] the infrastructure to allow different lock levels for relation options. > > So per discussion [2] the attached patch reduce lock levels down to ShareUpdateExclusiveL

[HACKERS] Reduce lock levels others reloptions in ALTER TABLE

2016-02-29 Thread Fabrízio de Royes Mello
Hi all, Some time ago we added [1] the infrastructure to allow different lock levels for relation options. So per discussion [2] the attached patch reduce lock levels down to ShareUpdateExclusiveLock for: - fastupdate - fillfactor - gin_pending_list_limit - seq_page_cost - random_page_cost - n_di