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

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 5/4/2017 2:50 PM, John R Pierce wrote:

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

oh, it should be made clear... both of these extensions require an OS level cron/scheduler job to be run every minute or whatever, this job invokes some SQL stuff which checks the pg_cron or pg_agent tables and runs whatever sql tasks are due.

-- 
john r pierce, recycling bits in santa cruz