Re: [GENERAL] Autovacuum Improvements

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: [GENERAL] Autovacuum Improvements
Дата
Msg-id 45B51BE3.9050809@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Autovacuum Improvements  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: [GENERAL] Autovacuum Improvements  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
Gregory Stark wrote:
> 
> Actually no. A while back I did experiments to see how fast reading a file
> sequentially was compared to reading the same file sequentially but skipping
> x% of the blocks randomly. The results were surprising (to me) and depressing.
> The breakeven point was about 7%. [...]
> 
> The theory online was that as long as you're reading one page from each disk
> track you're going to pay the same seek overhead as reading the entire track.

Could one take advantage of this observation in designing the DSM?

Instead of a separate bit representing every page, having each bit
represent 20 or so pages might be a more useful unit.  It sounds
like the time spent reading would be similar; while the bitmap
would be significantly smaller.


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

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: 10 weeks to feature freeze (Pending Work)
Следующее
От: Adriaan van Os
Дата:
Сообщение: Re: [BUGS] BUG #2907: pg_get_serial_sequence quoting