2012/3/6 Tom Lane <t...@sss.pgh.pa.us>: > Robert Haas <robertmh...@gmail.com> writes: >> On Mon, Mar 5, 2012 at 5:03 PM, Artur Litwinowicz <ad...@ybka.com> wrote: >>> Regarding a functional area I can help... but I can not understand why >>> this idea is so unappreciated? > >> I think it's a bit unfair to say that this idea is unappreciated. > > Well, there is the question of why we should re-invent the cron wheel. > >> There are LOTS of good features that we don't have yet simply because >> nobody's had time to implement them. > > Implementation work is only part of it. Any large feature will create > an ongoing, distributed maintenance overhead. It seems entirely > possible to me that we'd not accept such a feature even if someone > dropped a working implementation on us. > > But having said that, it's not apparent to me why such a thing would > need to live "inside the database" at all. It's very easy to visualize > a task scheduler that runs as a client and requires nothing new from the > core code. Approaching the problem that way would let the scheduler > be an independent project that stands or falls on its own merits.
There are a few arguments for scheduler in core * platform independence * possible richer workflow and loging possibilities or as minimum - better integration with SP * when application has lot of business logic in stored procedures, then outer scheduler is little bit foreign element - harder maintaining, harder configuration * when somebody would to implement some like materialised views, then have to have use outer schedule for very simple task - just exec SP every 5 minutes so I think there are reason why we can have a scheduler on core - simple or richer, but it can helps. cron and similar works, but maintaining of external scheduler is more expensive then using some simple scheduler in core. Regards Pavel > > 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers