X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B2E9D6FAA for ; Mon, 22 Aug 2005 12:56:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62705-10 for ; Mon, 22 Aug 2005 15:56:50 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E5321D6DA1 for ; Mon, 22 Aug 2005 12:56:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7MFudpe016419; Mon, 22 Aug 2005 11:56:39 -0400 (EDT) To: Bruce Momjian Cc: Michael Fuhr , Don Drake , John DeSoi , Guido Barosio , pgsql-admin@postgresql.org Subject: Re: sleep? In-reply-to: <200508221424.j7MEObk10012@candle.pha.pa.us> References: <200508221424.j7MEObk10012@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Mon, 22 Aug 2005 10:24:37 -0400" Date: Mon, 22 Aug 2005 11:56:39 -0400 Message-ID: <16418.1124726199@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/267 X-Sequence-Number: 18586 Bruce Momjian writes: > Michael Fuhr wrote: >> Do you have any use cases in addition to what's already been >> mentioned? Sleeping isn't really a database operation, so there >> needs to be some justification for making it a standard function. > Well, we needed it for our own regression tests, so I assume others > would need it as well. ... and you'll notice that the regression test that uses it is still failing intermittently on some of the buildfarm machines, which rather calls the whole approach into question ... regards, tom lane