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. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
