Home > mailing lists

Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. ); - Mailing list pgsql-hackers

From	Fabrízio de Royes Mello
Subject	Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. );
Date	March 27, 2015 22:23:32
Msg-id	CAFcNs+oX7jVENC_3i54fDQ3ibmOGmknc2tMevdSmvojbSXGbGg@mail.gmail.com Whole thread Raw
Responses	Re: Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. ); (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List	pgsql-hackers

Tree view

Hi all,

I'm tweaking some autovacuum settings in a table with high write usage but with ALTER TABLE .. SET ( .. ) this task was impossible, so I did a catalog update (pg_class) to change reloptions.

Maybe it's a stupid doubt, but why we need to get an AccessExclusiveLock on relation to set reloptions if we just touch in pg_class tuples (RowExclusiveLock) ?

Regards,

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

pgsql-hackers by date:

From: Pavel Stehule
Date: 27 March 2015, 20:41:12
Subject: Re: Bug fix for missing years in make_date()

From: Alexander Korotkov
Date: 27 March 2015, 22:50:23
Subject: Re: GSoC 2015 proposal. Bitmap Index-only Count

Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. ); - Mailing list pgsql-hackers

Previous

Next