From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Reduce lock levels others reloptions in ALTER TABLE |
Date: | 2016-02-29 17:58:54 |
Message-ID: | CAFcNs+qZ+ykPjj01aU1hsqgsMun3Ae_YnWOdB4-8X727_7svPw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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,
[1]
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=47167b7907a802ed39b179c8780b76359468f076
[2]
http://www.postgresql.org/message-id/20150731022857.GC11473@alap3.anarazel.de
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello
Attachment | Content-Type | Size |
---|---|---|
reduce-locklevel-for-other-reloptions_v1.patch | text/x-diff | 4.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Fabrízio de Royes Mello | 2016-02-29 18:01:17 | Re: Reduce lock levels others reloptions in ALTER TABLE |
Previous Message | Tom Lane | 2016-02-29 17:53:03 | Re: WIP: Upper planner pathification |