Re: table size growing out of control

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Treat <rtreat(at)webmd(dot)net>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: table size growing out of control
Date: 2002-07-17 15:59:41
Message-ID: 14389.1026921581@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Robert Treat <rtreat(at)webmd(dot)net> writes:
> ok. but my ps aux | grep postgres did label all connections as idle,
> which should be equivalent, right?

If it said "idle" and not "idle in transaction" then yes ... but make
sure your ps isn't truncating the string such that you can't see
the "in transaction" part.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2002-07-17 16:01:07 Re: [GENERAL] SysAdmin magazine is doing a "Call for Papers" about
Previous Message Steve Brett 2002-07-17 15:50:50 just a quick one ...