Thread: sleep function

sleep function

From
John DeSoi
Date:
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.



Re: sleep function

From
Bruce Momjian
Date:
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,
Pennsylvania19073
 


Re: sleep function

From
John DeSoi
Date:
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;
endif;    end loop;
 
    return later;end;
' language plpgsql;



Re: sleep function

From
Greg Stark
Date:
John DeSoi <jd@icx.net> 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



Re: sleep function

From
John DeSoi
Date:
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.



Re: sleep function

From
Sanjay Singh
Date:
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 <jd@icx.net> 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              |
*********************************************