Re: autovacuum question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In article <20090204165933.GB32680@xxxxxxxxxxxxxx>,
Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux