From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
---|---|
To: | Vikram Kulkarni <vkulkarn(at)brownforces(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 7.4.2 Regression tests: test stats loops indefinately... |
Date: | 2004-05-03 21:54:54 |
Message-ID: | 64fd90tqsoue4mljbug4og6k5kksguq608@email.aon.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 3 May 2004 14:17:11 -0400, Vikram Kulkarni
<vkulkarn(at)brownforces(dot)org> wrote:
>the end of results/stats.out is:
>-- let stats collector catch up
>SELECT sleep('0:0:2'::interval);
>
>everything up till and including that matches expected/stats.out... but
>the test simply stalls there. Unless I manuall kill the process, the
>postmaster simply keeps soaking up CPU time indefinately.
Please try this interactively in a psql session:
CREATE FUNCTION sleep(interval) RETURNS integer AS '
DECLARE
endtime timestamp;
BEGIN
endtime := timeofday()::timestamp + $1;
WHILE timeofday()::timestamp < endtime LOOP
END LOOP;
RETURN 0;
END;
' LANGUAGE 'plpgsql';
SELECT timeofday();
SELECT timeofday()::timestamp;
-- wait a few seconds ...
SELECT timeofday()::timestamp;
SELECT timeofday()::timestamp + '0:0:2'::interval;
SELECT sleep('0:0:2'::interval);
... and tell us what happens.
From | Date | Subject | |
---|---|---|---|
Next Message | Sumita Biswas | 2004-05-03 22:01:25 | Date addition using Interval |
Previous Message | Ericson Smith | 2004-05-03 21:31:51 | Re: XID Data Types |