Re: maintenance_work_mem and autovacuum - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: maintenance_work_mem and autovacuum
Date
Msg-id 86D5C19DB18D86789964F7D9@teje
Whole thread Raw
In response to Re: maintenance_work_mem and autovacuum  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
--On Donnerstag, März 26, 2009 13:43:45 -0700 Josh Berkus
<josh@agliodbs.com> wrote:

> I actually have a client who does both automated and manual vacuums.
> Having two settings would definitely be convenient for them.

I often found people doing this running within a) their own superuser with
special GUCs set or b) using their own scripts which are setting
maintenance_work_mem accordingly.

Often people are very confused about the number of *_vaccum_* settings
already present: they sometimes have a really hard time to learn the
difference between manual and auto vaccum and the interaction of
default/inherited settings.

That said, having a separate setting would be consequent, but it seems to
me it's enough there to satisfy all needs, isn't it?

--  Thanks
                   Bernd


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: maintenance_work_mem and autovacuum
Next
From: Emmanuel Cecchet
Date:
Subject: Re: Partitioning feature ...