Re: Free Space Map thoughts

On Thu, 2007-11-08 at 21:50 -0300, Alvaro Herrera wrote:
> Simon Riggs wrote:
> 
> > Presumably we would not store an FSM for small tables? On the basis that
> > the purpose of the FSM is to save on pointless I/O there must be a size
> > of table below which an FSM is just overhead.
> 
> Hmm, do you mean that we would open and verify every page of a small
> relation until we find one with free space?  That doesn't sound very
> good.

I was trying to guess at Heikki's reason for saying the FSM should be in
a separate file. If we have one extra file per table that seems like a
huge number of additional files, with space and fsync implications.
Let's wait and see what Heikki's answer is.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com