Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock

Robert Haas wrote:
> On Wed, Jul 7, 2010 at 9:04 PM, C?dric Villemain
> <cedric(dot)villemain(dot)debian(at)gmail(dot)com> wrote:
> >>> > I assume this did not get done for 9.0. ?Do we want a TODO item?
> >>>
> >>> Yes.
> >>
> >> Added:
> >>
> >> ? ? ? ?Reduce locking required for ALTER commands
> >
> > 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)
> >
> > Can we add some mechanism to prevent that situation also in the TODO item ?
> >
> > (alternative is actualy to alter other tables and adjust the
> > postgresql.conf for biggest tables, but not an ideal solution anyway)
> >
> >>
> >> ? ? ? ? ? ?* http://archives.postgresql.org/pgsql-hackers/2009-08/msg00533.php
> >> ? ? ? ? ? ?* http://archives.postgresql.org/pgsql-hackers/2009-10/msg01083.php
> >> ? ? ? ? ? ?* http://archives.postgresql.org/pgsql-hackers/2010-01/msg02349.php
>
> Bruce, that last link is about something else completely. Here are
> some better ones:
>
> http://archives.postgresql.org/pgsql-hackers/2008-10/msg01248.php
> http://archives.postgresql.org/pgsql-hackers/2008-10/msg00242.php

Thanks, TODO updated.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +