Re: [HACKERS] proposal: custom autovacuum entries - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] proposal: custom autovacuum entries
Date
Msg-id 26901.1509050855@sss.pgh.pa.us
Whole thread Raw
In response to [HACKERS] proposal: custom autovacuum entries  (Jordan Deitch <jwdeitch@gmail.com>)
Responses Re: [HACKERS] proposal: custom autovacuum entries
List 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 by date:

Previous
From: Jordan Deitch
Date:
Subject: [HACKERS] proposal: custom autovacuum entries
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] taking stdbool.h into use