Postgres Pro
Downloads
Home   >   mailing lists

Reduce lock levels others reloptions in ALTER TABLE - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Reduce lock levels others reloptions in ALTER TABLE
Date
Msg-id CAFcNs+qZ+ykPjj01aU1hsqgsMun3Ae_YnWOdB4-8X727_7svPw@mail.gmail.com
Whole thread Raw
Responses Re: Reduce lock levels others reloptions in ALTER TABLE
Re: Reduce lock levels others reloptions in ALTER TABLE
List pgsql-hackers
Tree view
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_distinct
- n_distinct_inherited
- buffering

Att,
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP: Upper planner pathification
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: Reduce lock levels others reloptions in ALTER TABLE