Re: usleep feature for pgbench

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: usleep feature for pgbench
Дата
Msg-id 468E8B71.90602@Yahoo.com
обсуждение исходный текст
Ответ на Re: usleep feature for pgbench  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Bgwriter strategies
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Bgwriter strategies