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 <[EMAIL PROTECTED]> 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?

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to