X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 71E9C9FB91A for ; Fri, 25 Aug 2006 07:52:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19338-04 for ; Fri, 25 Aug 2006 07:52:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id E957C9FB34B for ; Fri, 25 Aug 2006 07:52:48 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GGZW8-0004EJ-5n; Fri, 25 Aug 2006 07:06:28 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id A980A4172; Fri, 25 Aug 2006 06:52:34 -0400 (EDT) Date: Fri, 25 Aug 2006 06:52:34 -0400 From: Andrew Sullivan To: =?iso-8859-1?Q?Andr=E9_Jos=E9?= Guergolet Cc: Andrew Sullivan , pgsql-sql@postgresql.org Subject: Re: RES: Lock Problem Message-ID: <20060825105234.GA25981@phlogiston.dyndns.org> References: <3FFA1818C1550246933DEA311C39B07612304A@CGEXC03.compugraf.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <3FFA1818C1550246933DEA311C39B07612304A@CGEXC03.compugraf.com.br> User-Agent: Mutt/1.5.9i Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.265 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/200 X-Sequence-Number: 26158 On Thu, Aug 24, 2006 at 06:12:32PM -0300, Andr=E9 Jos=E9 Guergolet wrote: >=20 > My system, checks if my script is running in each machine at this > table, this table has 360 rows and has 50-100 updates per minute in > columns STATE and STATEDATE. How often are you vacuuming it? Long-running UPDATEs with that many updates per minure makes me think that maybe you have a lot of dead rows. Anyway, none of this supports your claim that you're getting table locks. The place to see what locks you are getting is pg_locks. A --=20 Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism.=20 --Brad Holland