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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Sep 01, 2006 at 10:43:30AM -0400, Tom Lane wrote:
> Matteo Sgalaberni <sgala@xxxxxxxxx> 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




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux