Postgres Pro
Downloads
Home   >   mailing lists

Re: Frequent 'deadlock detected' in 7.4 ... or just my bad code? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Frequent 'deadlock detected' in 7.4 ... or just my bad code?
Date
Msg-id 13458.1081186878@sss.pgh.pa.us
Whole thread Raw
In response to Frequent 'deadlock detected' in 7.4 ... or just my bad code?  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-admin
Tree view 
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> D'oh ... just tested my assumption, it was wrong ... *sigh*  okay, back
> to the drawing board on the code ...

Can't you just change

>> foreach $company_id ( keys %traffic ) {

to

>> foreach $company_id ( sort keys %traffic ) {

etc.

            regards, tom lane

pgsql-admin by date:

Previous
From: Erland Sommarskog
Date:
Subject: Re: what is the impact of Database size on Performemce
Next
From: bud.curtis@direcway.com (Bud Curtis)
Date:
Subject: Problem after RH9 Install of 7.4.2