Re: Small FSM is too large

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Small FSM is too large
Дата
Msg-id 4C1E5253.2060608@enterprisedb.com
обсуждение исходный текст
Ответ на Small FSM is too large  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: stats collector "connection refused" on recv of test message
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: beta3 & the open items list