Re: PGSQL 7.4.8 : idle in transaction problem

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
Cc: Mailing List Postgres-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PGSQL 7.4.8 : idle in transaction problem
Date: 2005-07-21 16:11:09
Message-ID: 20050721161109.GG24366@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 (<alvherre[a]alvh.no-ip.org>)
"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)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio C. Bon 2005-07-22 11:59:14 Error: No se pudo localizar un registro de checkpoint valido ¿ Como soluciono ?
Previous Message Oleg Bartunov 2005-07-21 16:02:10 Re: N-to-N implementation