X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 367E152B63 for ; Thu, 21 Jul 2005 13:11:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96721-05 for ; Thu, 21 Jul 2005 16:11:08 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id F324652A91 for ; Thu, 21 Jul 2005 13:11:03 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA01725F81; Thu, 21 Jul 2005 12:10:13 -0400 Received: from smtp2.surnet.cl (mr2.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Thu, 21 Jul 2005 16:10:13 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE300E2661F; Thu, 21 Jul 2005 12:10:13 -0400 Received: from alvh.no-ip.org (200.85.218.66) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF60004B5270; Thu, 21 Jul 2005 12:10:36 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id AF5F7C3711D; Thu, 21 Jul 2005 12:11:09 -0400 (CLT) Date: Thu, 21 Jul 2005 12:11:09 -0400 From: Alvaro Herrera To: Brad Nicholson Cc: Mailing List Postgres-Admin Subject: Re: PGSQL 7.4.8 : idle in transaction problem Message-ID: <20050721161109.GG24366@alvh.no-ip.org> References: <42DD5955.8000501@lexum.umontreal.ca> <11430.1121827475@sss.pgh.pa.us> <20050720051115.GA19849@alvh.no-ip.org> <15465.1121866521@sss.pgh.pa.us> <42DFB541.2060901@ca.afilias.info> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <42DFB541.2060901@ca.afilias.info> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.39 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200507/180 X-Sequence-Number: 18236 On Thu, Jul 21, 2005 at 10:46:25AM -0400, Brad Nicholson wrote: > From a Slony-I users standpoint - the idle transactions cause > pg_listener bloat, which can impact replication performance on busy sites. I think that problem has a different solution, which is to rewrite the listen/notify mechanism. -- Alvaro Herrera () "Find a bug in a program, and fix it, and the program will work today. Show the program how to find and fix a bug, and the program will work forever" (Oliver Silfridge)