sleep function

Is there a sleep function of some kind? I wanted to simulate a query
taking a long time to execute for testing purposes.

Thanks,

John DeSoi, Ph.D.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: sleep function

John DeSoi wrote:
> Is there a sleep function of some kind? I wanted to simulate a query
> taking a long time to execute for testing purposes.

I can't think of one, no. I think you will have to use one of the
server-side languages and call a sleep in there.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Re: sleep function

On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote:

> I can't think of one, no. I think you will have to use one of the
> server-side languages and call a sleep in there.


This is no good in the real world since it pounds the CPU, but it
worked well enough for my testing purposes.

Best,

John DeSoi, Ph.D.




create or replace function sleep (integer) returns time as '
declare
seconds alias for $1;
later time;
thetime time;
begin
thetime := timeofday()::timestamp;
later := thetime + (seconds::text || '' seconds'')::interval;
loop
if thetime >= later then
exit;
else
thetime := timeofday()::timestamp;
end if;
end loop;

return later;
end;
' language plpgsql;


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: sleep function

John DeSoi writes:

> On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote:
>
> > I can't think of one, no. I think you will have to use one of the
> > server-side languages and call a sleep in there.
>
> This is no good in the real world since it pounds the CPU, but it worked well
> enough for my testing purposes.

You went the long way around. I think what he meant was something as simple
as:

bash-2.05b$ /usr/lib/postgresql/bin/createlang -U postgres plperlu test

bash-2.05b$ psql -d test -U postgres
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=# create or replace function sleep(integer) returns integer as 'return sleep(shift)' language plperlu;
CREATE FUNCTION

test=# \timing
Timing is on.

test=# select sleep(10) ;
sleep
-------
10
(1 row)

Time: 10002.493 ms


--
greg


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: sleep function

Hi Greg,

On Aug 22, 2004, at 11:52 PM, Greg Stark wrote:

> test=# create or replace function sleep(integer) returns integer as
> 'return sleep(shift)' language plperlu;
> CREATE FUNCTION
>

The original request was for something in built-in to PostgreSQL. I
have not used plperl (or any of the other pl languages), but I assume
there will be additional installation and configuration issues to use
them. But thanks for the example, it will be helpful if I need
something more processor friendly.

Best,

John DeSoi, Ph.D.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: sleep function

Hi All,
I am getting this message while I am trying to implement tsearch.

java.sql.SQLException: ERROR: could not find tsearch config by locale

what could be the problem
Please help
bye
Sanjay


Greg Stark wrote:
> John DeSoi writes:
>
>
>>On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote:
>>
>>
>>>I can't think of one, no. I think you will have to use one of the
>>>server-side languages and call a sleep in there.
>>
>>This is no good in the real world since it pounds the CPU, but it worked well
>>enough for my testing purposes.
>
>
> You went the long way around. I think what he meant was something as simple
> as:
>
> bash-2.05b$ /usr/lib/postgresql/bin/createlang -U postgres plperlu test
>
> bash-2.05b$ psql -d test -U postgres
> Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> test=# create or replace function sleep(integer) returns integer as 'return sleep(shift)' language plperlu;
> CREATE FUNCTION
>
> test=# \timing
> Timing is on.
>
> test=# select sleep(10) ;
> sleep
> -------
> 10
> (1 row)
>
> Time: 10002.493 ms
>
>

--
Sanjay Singh

*********************************************
| Scientific Officer / D, |
| Library & Information Services, |
| Indira Gandhi Centre for Atomic Research, |
| Kalpakkam - 603102, Tamil Nadu (India) |
| Phone : 0091 4114 280096(O) |
| 0091 9894258801(R) |
| Email : sanjjay@igcar.ernet.in |
| sanjjay_in@yahoo.com |
*********************************************


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match