Re: [HACKERS] proposal: custom autovacuum entries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] proposal: custom autovacuum entries
Дата
Msg-id 26901.1509050855@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] proposal: custom autovacuum entries  (Jordan Deitch <jwdeitch@gmail.com>)
Ответы Re: [HACKERS] proposal: custom autovacuum entries  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
Jordan Deitch <jwdeitch@gmail.com> writes:
> I would like to remove records from a time series table older than a
> certain age. My understanding of current standard practice is to configure
> an external scheduler like cron to perform the deletion.
> My proposal is to allow clients to register functions on the tail end of
> the autovacuum sequence.

There's already a mechanism for writing custom background workers.
I doubt that adding random user-defined stuff to what autovacuum has
to do is a better idea; that will mostly make autovac scheduling even
harder than it is now.
        regards, tom lane


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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jordan Deitch
Дата:
Сообщение: [HACKERS] proposal: custom autovacuum entries
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] taking stdbool.h into use