Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis,amqp, s3 in the future?

On 5/4/2017 2:08 PM, Sven R. Kunze wrote:
> After searching the web, it seems to me that PostgreSQL doesn't offer
> a cron-like background job for cleanup tasks.
>
> http://stackoverflow.com/questions/18187490/postgresql-delete-old-rows-on-a-rolling-basis
>
>
>
> But there's an extension - pg_cron:
> https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/


there's also pg_agent which is a cron-like extension, usually bundled
with pg_admin but also available standalone

https://www.pgadmin.org/docs4/dev/pgagent.html


--
john r pierce, recycling bits in santa cruz