Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group