Re: SLEEP in posgresql - Mailing list pgsql-general

From Richard Huxton
Subject Re: SLEEP in posgresql
Date
Msg-id 470C9A5D.5070607@archonet.com
Whole thread Raw
In response to Re: SLEEP in posgresql  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
List 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 by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: Re: How to speedup intarray aggregate function?
Next
From: Richard Huxton
Date:
Subject: Re: ORDER BY - problem with NULL values