Re: 100% CPU at concurent access

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: 100% CPU at concurent access
Date: 2008-10-08 23:13:21
Message-ID: 1239.1223507601@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> writes:
> Then I try to use the following procedure to catch the concurrency access
> occurence and retry until both scripts succeed:

What makes you think they ever will succeed? Once one of these guys has
hit a failure, you've got a tight loop of retrying the same command and
getting the same failure.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dirk Jagdmann 2008-10-09 06:20:46 Re: Insert a space between each character
Previous Message Sabin Coanda 2008-10-08 16:56:13 100% CPU at concurent access