Re: SLEEP in posgresql

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: SLEEP in posgresql
Дата
Msg-id 470C9A5D.5070607@archonet.com
обсуждение исходный текст
Ответ на Re: SLEEP in posgresql  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
Список pgsql-general
Jasbinder Singh Bali wrote:
> I don't know how is a sleep of 1 second going to be harmful here instead of
> keeping a busy wait.
>
> Even if a=b is going to take 1 week as u say, isn't a sleep of 1 second, if
> nothing, would save some CPU resources instead of blindly looping for ever ?
> Aren't busy waits dangerous from CPU resources point of view ? Won't it keep
> my CPU busy for ever. Also, if there's a sleep of 1 second, is it going to
> give me some saving in CPU resources or not ?

It's not the sleep that people are saying is harmful. It's the waiting
in a loop in a transaction.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: "Dmitry Koterov"
Дата:
Сообщение: Re: How to speedup intarray aggregate function?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: ORDER BY - problem with NULL values