Re: Free space mapping (was Re: Multi-Versions and Vacuum)

Mark Kirkwood <markir@slingshot.co.nz>

From: Mark Kirkwood <markir@slingshot.co.nz>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-general@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>, Andrew Sullivan <andrew@libertyrms.info>
Date: 2002-08-27T22:39:28Z
Lists: pgsql-general
(mass snippage)
>The ever-growing tables
> that people are experiencing is somehow related to the new
> non-blocking vacuum and the value of the free space map settings...
>But if I understand now what you're saying, it's this: the vacuum
> _does_ get everything....

There is also a complicating effect when rows have toasted storage, which can prevent the space being freed (I think),
see hackers thread entitled something like "unbounded database growth".

I have set myself the task of examining this - but wish I had picked an easier 1st project :-(
- I am having to learn about vacuum, toasting ,freespace, and generally get to grips with the Pg code as well - just as well I have some free time at the moment...:-) 

best wishes

Mark