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

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis,amqp, s3 in the future?
Дата
Msg-id 2dd96f73-af70-1894-4ea9-cf90ed384019@hogranch.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis,amqp, s3 in the future?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
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

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis,amqp, s3 in the future?
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: [GENERAL] Caching and Blobs in PG? Was: Can PG replace redis, amqp, s3 in the future?