Re: High SYS CPU - need advise

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: High SYS CPU - need advise
Дата
Msg-id 27746.1353023571@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: High SYS CPU - need advise  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: High SYS CPU - need advise  (Vlad Marchenko <marchenko@gmail.com>)
Список pgsql-general
Merlin Moncure <mmoncure@gmail.com> writes:
> What I've been scratching my head over is what code exactly would
> cause an iterative sleep like the above.  The code is here:

>   pg_usleep(cur_delay * 1000L);

>   /* increase delay by a random fraction between 1X and 2X */
>   cur_delay += (int) (cur_delay *
>         ((double) random() / (double) MAX_RANDOM_VALUE) + 0.5);
>   /* wrap back to minimum delay when max is exceeded */
>   if (cur_delay > MAX_DELAY_MSEC)
>     cur_delay = MIN_DELAY_MSEC;

IIRC that coding is of relatively recent vintage.  The OP is probably
running some older version that increased cur_delay differently.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: Percent of Total in Histogram Query
Следующее
От: Vlad Marchenko
Дата:
Сообщение: Re: High SYS CPU - need advise