On Mon, Aug 22, 2005 at 11:53:22AM -0400, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > >> On Aug 22, 2005, at 12:40 AM, Michael Fuhr wrote: > >>> To others who've written their own sleep() function: what are you > >>> using it for? > > > I know I've used one for a script that reindexes various tables on an > > old 7.3 server. I put a sleep of 20 seconds between reindexes to let > > built up transactions have a few moments to catch up, thereby smoothing > > out i/o. For a long time I used a cpu hogging plpgsql version (since I > > had cpu to spare) until I switched to a better pltcl version. If a > > server side one existed I would certainly have used that. > > Tell you the truth, this "use case" qualifies as a poster child for my > concern that a server-side sleep would encourage people to write code > that sits on locks. If you'd coded some kind of plpgsql loop that did > a REINDEX, sleep N seconds, another REINDEX, etc, you'd have been > sitting on the exclusive lock for each table until the end of the whole > transaction. Your approach makes lots of sense if you commit each > REINDEX transaction and sleep *outside* the transaction --- but a server > sleep function would do exactly not that.
ISTM that when someone thinks they need a sleep in the database they'll go to the docs to see if such a capability exists. When they find out it does, hopefully they'll read far enough to see the nice big warning we'll put in there about it being a foot-gun. Then they'll be better informed about if they should actually be doing what they're thinking about doing. Right now, they see the function is missing and just cobble something else together, possibly without regard to the side-effects. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
