Re: [HACKERS] include/config.h FOLLOWUP

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] include/config.h FOLLOWUP
Дата
Msg-id 199801041905.OAA04251@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] include/config.h FOLLOWUP  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: [HACKERS] include/config.h FOLLOWUP  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
>     No, don't make it a run-time or auto-detect thing, just a compile time
> option.  By default, leave it at 8192, since "that's the way its always been"...
> but if we are justifying it based on disk block size, its 2x the disk block
> size that my system is setup for. What's the difference between that and making
> it 3x or 4x?  Or, hell, would I get a performance increase if I brought it
> down to 4096, which is what my actually disk block size is?
>
>     So, what we would really be doing is setting the default to 8192, but give
> the installer the opportunity (with a caveat that this value should be a multiple
> of default file system block size for optimal performance) to increase it as they
> see fit.

I assume you changed the default, becuase the BSD44 default is 8k
blocks, with 1k fragments.

I don't think there is any 'performance' improvement with making it
greater than the file system block size.

--
Bruce Momjian
maillist@candle.pha.pa.us

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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] include/config.h FOLLOWUP
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] include/config.h FOLLOWUP