elegant and effective way for running jobs inside a database

From: Artur Litwinowicz <admin(at)ybka(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: elegant and effective way for running jobs inside a database
Date: 2012-03-05 19:18:56
Message-ID: 4F5511A0.9000009@ybka.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dear Developers,
I am looking for elegant and effective way for running jobs inside a
database or cluster - for now I can not find that solution.
OK if You say "use cron" or "pgAgent" I say I know that solutions, but
the are not effective and elegant. Compilation of "pgAgent" is a pain
(especially wxWidgets usage on system with no X) - it can run jobs with
minimal 60s periods but what when someone needs run it faster for eg.
with 5s period ? Of course using cron I can do that but it is not
effective and elegant solution. Why PostgreSQL can not have so elegant
solution like Oracle database ? I am working with Oracle databases for
many years, but I like much more PostgreSQL project but this one
thing... I can not understand - the lack of jobs inside the database...

Best regards,
Artur

Attachment Content-Type Size
0xAF4A859D.asc application/pgp-keys 11.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2012-03-05 19:22:45 Re: RFC: Making TRUNCATE more "MVCC-safe"
Previous Message Noah Misch 2012-03-05 18:56:32 Re: ECPG FETCH readahead