Re: [GENERAL] Massive table bloat

2010-03-03 Thread Markus Wollny
> -Ursprüngliche Nachricht- > Von: Thom Brown [mailto:thombr...@gmail.com] > Gesendet: Mittwoch, 3. März 2010 16:56 > An: Markus Wollny > Cc: pgsql-general@postgresql.org > Betreff: Re: [GENERAL] Massive table bloat > If you update rows, it actually creates a new v

Re: [GENERAL] Massive table bloat

2010-03-03 Thread Grzegorz Jaśkiewicz
do a vacuum analyze verbose on it, and see if it complains about FSM (free space map) setting. Which it probably will be.

Re: [GENERAL] Massive table bloat

2010-03-03 Thread Thom Brown
On 3 March 2010 15:33, Markus Wollny wrote: > Hi! > > I've set up some system to track slow page executions in one of our (as > yet not live) web apps. The tracking itself is handled completely within > the database using a function. Within a very short time (approx. 1 week) > and although we have