Re: autovacuum question

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: autovacuum question
Дата
Msg-id pu7i459jme.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на autovacuum question  ("Marc Mamin" <M.Mamin@intershop.de>)
Ответы Re: autovacuum question  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: raf
Дата:
Сообщение: Re: How to prevent users from creating tables
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: question about measuring shared_buffers usage