Horton
Menu

Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, Peter Eisentraut <peter_e@gmx.net>, Simon Riggs <simon@2ndQuadrant.com>, Alvaro Herrera <alvherre@commandprompt.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2010-07-08T01:37:08Z
Lists: pgsql-hackers 
On 7/7/10 6:04 PM, Cédric Villemain wrote:
> I just faced production issue where it is impossible to alter table to
> adjust autovacuum settings in a pg8.4. (5K tps, 260M rows table, lock
> too much)

We could try to resolve the COMMENT ON issue with the same mechanism.
What we need is a table lock which blocks other DDL statements, but not DML.

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com