[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

Re: [GENERAL] Massive table bloat

2010-03-03 Thread Thom Brown
On 3 March 2010 15:33, Markus Wollny markus.wol...@computec.de 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)

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 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 version of it. The old one