From: Harald Fuchs <hari.fuchs@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: autovacuum question
Date: Thu, 05 Feb 2009 13:02:49 +0100
Message-ID: <pu7i459jme.fsf@srv.protecting.net> (raw)
References: <C4DAC901169B624F933534A26ED7DF311D5398@JENMAIL01.ad.intershop.net>
<20090204165933.GB32680@alvh.no-ip.org>
In article <20090204165933.GB32680@alvh.no-ip.org>,
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Marc Mamin wrote:
>> There are 2 features that would be helpfull in my case:
>>
>> - define vacuum properties on table groups rather than on given tables:
>>
>> For example, I don't want to vacuum daily tables which can be
>> identified with a regexp:
>> tablename ~ '\.*d_[0-9]{8}'
> Hmm. I'm not really sure how could we handle this kind of situation.
Couldn't we use schemas for that? Put all those tables into a
separate schema and somehow tell autovacuum to leave that schema
alone.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: hari.fuchs@gmail.com
Subject: Re: autovacuum question
In-Reply-To: <pu7i459jme.fsf@srv.protecting.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox