TODO-item: Add sleep() function, remove from regress.c
От | Joachim Wieland |
---|---|
Тема | TODO-item: Add sleep() function, remove from regress.c |
Дата | |
Msg-id | 20060110000311.GA18542@mcknight.de обсуждение исходный текст |
Ответы |
Re: TODO-item: Add sleep() function, remove from regress.c
Re: TODO-item: Add sleep() function, remove from regress.c |
Список | pgsql-patches |
I propose the appended patch for the todo item: * Add sleep() function, remove from regress.c The patch also removes do_sleep() from the regression and substitues this with the call to the new function. I'd personally prefer to call the function pg_sleep(), but since it is called sleep() on the TODO list and in previous discussions, I kept the name. The internal function is called pg_sleep() however. There was a discussion about this item in August of last year http://archives.postgresql.org/pgsql-hackers/2005-08/msg00633.php A few people liked the idea, Tom Lane pointed out that it's bad to have a sleeping backend that can hold locks for a long time. Other developers answered that this should just be documented since the user can do that anyways very easily if he is allowed to create functions in one of the traditional scripting languages or with busy waiting also in plpgsql. Finally the item got added to the TODO list and nobody objected. In the mysqlcompat project there is a sleep function that does busy waiting, this function could profit from a sleep() function in the backend. To the docs I introduced a new paragraph such that it is easy to find this function and labeled the note about the locks with the "warning" tag. Tom, can you live with that? Other Comments? Joachim
Вложения
В списке pgsql-patches по дате отправления: