Re: usleep feature for pgbench - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: usleep feature for pgbench
Date
Msg-id 468E8B71.90602@Yahoo.com
Whole thread Raw
In response to Re: usleep feature for pgbench  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
On 7/6/2007 1:32 PM, Heikki Linnakangas wrote:
> Jan Wieck wrote:
>> On 7/6/2007 10:44 AM, Peter Eisentraut wrote:
>>> Am Donnerstag, 5. Juli 2007 21:12 schrieb Jan Wieck:
>>>> To test some changes in Slony I needed a
>>>>
>>>>      \usleep [microseconds|:variable]
>>>>
>>>> in pgbench's scripting language to be able to have hundreds of
>>>> concurrent running transactions without totally swamping the system. I
>>>> was wondering if anyone would object to permanently adding this to the
>>>> pgbench code?
>>>
>>> Or maybe a \sleep command that takes units, if it's not too much work.
>>>
>> 
>> You mean as a second, optional argument? Good idea.
>> 
>>   us = microseconds
>>   ms = milliseconds
>>   s  = seconds (default)
>> 
>>   \sleep {value|:variable} [us|ms|s]
>> 
>> Is that okay with everyone?
> 
> I won't object, but is it really worth the trouble?
> 
> Can you do microsecond precision sleeps, and on what platforms? How much 
> overhead is there? IIRC, on Linux the minimum time you can sleep depends 
> on CONFIG_HZ, and the default was 10 ms until recently.
> 

It is what you tell select(2) in the struct timeval. Why limit it to 
some arbitrary precision?


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Bgwriter strategies
Next
From: Greg Smith
Date:
Subject: Re: Bgwriter strategies