Re: database bloat,non removovable rows, slow query etc...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matteo Sgalaberni <sgala(at)sgala(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: database bloat,non removovable rows, slow query etc...
Date: 2006-09-01 14:43:30
Message-ID: 4027.1157121810@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Matteo Sgalaberni <sgala(at)sgala(dot)com> writes:
> 22 daemons that have a persistent connection to this database(all
> connection are in "idle"(no transaction opened).

You may think that, but you are wrong.

> INFO: "cliente": found 0 removable, 29931 nonremovable row versions in 559 pages
> DETAIL: 29398 dead row versions cannot be removed yet.

The only way the above can happen is if there are some fairly old open
transactions. Looking in pg_stat_activity might help you identify the
culprit(s).

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick Hatcher 2006-09-01 15:33:34 Re: database bloat,non removovable rows, slow query etc...
Previous Message Matteo Sgalaberni 2006-09-01 12:39:15 database bloat,non removovable rows, slow query etc...