Small FSM is too large

Started by Simon Riggsover 15 years ago2 messages
#1Simon Riggs
simon@2ndQuadrant.com

I notice that if I vacuum a 1 row table I get a FSM that is 24576 bytes
in size, or 3 database blocks.

Why is it not 1 block, or better still 0 blocks for such a small table?

--
Simon Riggs www.2ndQuadrant.com

#2Heikki Linnakangas
heikki.linnakangas@enterprisedb.com
In reply to: Simon Riggs (#1)
Re: Small FSM is too large

On 20/06/10 13:56, Simon Riggs wrote:

I notice that if I vacuum a 1 row table I get a FSM that is 24576 bytes
in size, or 3 database blocks.

Why is it not 1 block, or better still 0 blocks for such a small table?

It was just less code to write and test that way. The FSM tree is always
constant height, three levels, to keep things simple.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com