Re: database bloat,non removovable rows, slow query

On Fri, 2006-09-01 at 12:28, Matteo Sgalaberni wrote:
> 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?

Something is holding a lock, somewhere.

Have you tried shutting down and restarting the database to see if you
can get it to vacuum that way? You're not in a transaction in psql,
right?