X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4DF42D1B9EB; Mon, 5 Apr 2004 18:12:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84384-10; Mon, 5 Apr 2004 15:13:14 -0300 (ADT) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 81D8CD1B54E; Mon, 5 Apr 2004 15:12:43 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 6FFE54512D; Mon, 5 Apr 2004 15:13:33 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 5E81745125; Mon, 5 Apr 2004 15:13:33 -0300 (ADT) Date: Mon, 5 Apr 2004 15:13:33 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: Tom Lane Cc: "Marc G. Fournier" , pgsql-admin@postgresql.org Subject: Re: Frequent 'deadlock detected' in 7.4 ... or just my bad In-Reply-To: <13458.1081186878@sss.pgh.pa.us> Message-ID: <20040405151122.C79409@ganymede.hub.org> References: <20040405114031.N79409@ganymede.hub.org> <11570.1081178034@sss.pgh.pa.us> <20040405141728.C79409@ganymede.hub.org> <20040405143824.D79409@ganymede.hub.org> <13458.1081186878@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/53 X-Sequence-Number: 13026 On Mon, 5 Apr 2004, Tom Lane wrote: > "Marc G. Fournier" 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. Ya, just saw the note from Matt on that also ... didn't realize it was *that* simple ... was going to look into using the NULL Berkeley DB driver ... the O'Reilly Programming Perl book that I have, when you look into the index at the back under Hashes: Automatic Sorting Of talks about the Berkeley DB driver ... and that's it, nothing about simple sorting like the above ... even if you look under 'Sorting: Hashes automatically', it points to the same thing ... Talk about over-complicating things :( ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664