Re: New FSM patch

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: New FSM patch
Дата
Msg-id 48CA8A71.3020005@enterprisedb.com
обсуждение исходный текст
Ответ на Re: New FSM patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> Let me describe this test case first:
>> - The test program calls RecordAndGetPageWithFreeSpace in a tight loop, 
>> with random values.
> 
> What's the distribution of the random values, exactly?  In particular,
> how do the request sizes compare to available free space per-page?

The request, and "old avail" sizes are in the range of 0-8100 
(random()%8100).

> The design intent for FSM was that we'd not bother to record pages that
> have less free space than the average request size, so as to (usually)
> avoid the problem of uselessly searching a lot of entries.  I can't tell
> whether your test case models that behavior at all.  If it does then
> there may be something else that needs fixing.

Probably not. The test case starts with a table that's practically 
empty, so all pages are put into the FSM.

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


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: New FSM patch
Следующее
От: David Fetter
Дата:
Сообщение: Re: Move src/tools/backend/ to wiki