Re: autovacuum question

From: Harald Fuchs <hari(dot)fuchs(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: autovacuum question
Date: 2009-02-05 12:02:49
Message-ID: pu7i459jme.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <20090204165933(dot)GB32680(at)alvh(dot)no-ip(dot)org>,
Alvaro Herrera <alvherre(at)commandprompt(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2009-02-05 13:18:18 question about measuring shared_buffers usage
Previous Message raf 2009-02-05 02:00:38 Re: How to prevent users from creating tables