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

[GENERAL] Massive table bloat

2010-03-03 Thread Markus Wollny
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 haven't got that much traffic on our testpages, the table in