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

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

On Fri, Sep 01, 2006 at 10:43:30AM -0400, Tom Lane wrote:
> 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.
Ok. I stopped all clients. No connections to this database. Only psql
console. Made vacuum
full/freeze all cominations... again dead rows non removable. Nothing
changed as in production.

this is my postgres config:

http://pastebin.com/781480

I read a lot about bloat tables related to
not appropriate fsm settings... can be the mine a case of
misconfiguration of these parameters?

Thx

Matteo

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-09-01 17:35:20 Re: database bloat,non removovable rows, slow query etc...
Previous Message Guillaume Cottenceau 2006-09-01 17:00:52 increasing shared buffers: how much should be removed from OS filesystem cache?