Re: autovacuum question - Mailing list pgsql-admin

From Harald Fuchs
Subject Re: autovacuum question
Date
Msg-id pu7i459jme.fsf@srv.protecting.net
Whole thread Raw
In response to autovacuum question  ("Marc Mamin" <M.Mamin@intershop.de>)
Responses Re: autovacuum question  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: raf
Date:
Subject: Re: How to prevent users from creating tables
Next
From: Rajesh Kumar Mallah
Date:
Subject: question about measuring shared_buffers usage