Excerpts from Merlin Moncure's message of mar mar 06 19:07:51 -0300 2012: > > On Tue, Mar 6, 2012 at 4:01 PM, Alvaro Herrera > <alvhe...@commandprompt.com> wrote: > > Why do we need a ticker? Just fetch the time of the task closest in the > > future, and sleep till that time or a notify arrives (meaning schedule > > change). > > Because that can't be done in userland (at least, not without stored > procedures) since you'd have to keep an open running transaction while > sleeping.
I was thinking that the connection would be kept open but no query would be running. Does this preclude reception of notifies? I mean, you don't sleep via "SELECT pg_sleep()" but rather a select/poll in the daemon. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
