Re: database bloat,non removovable rows, slow query etc... - Mailing list pgsql-performance

From Matteo Sgalaberni
Subject Re: database bloat,non removovable rows, slow query etc...
Date
Msg-id 20060901172829.GX2266@sgala.com
Whole thread Raw
In response to Re: database bloat,non removovable rows, slow query etc...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: database bloat,non removovable rows, slow query etc...
Re: database bloat,non removovable rows, slow query
List pgsql-performance
On Fri, Sep 01, 2006 at 10:43:30AM -0400, Tom Lane wrote:
> Matteo Sgalaberni <sgala@sgala.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



pgsql-performance by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: increasing shared buffers: how much should be removed from OS filesystem cache?
Next
From: Tom Lane
Date:
Subject: Re: database bloat,non removovable rows, slow query etc...