Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579018FE16D@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
> I don't doubt that there may be a positive effect from increasing the
> block size.  But we haven't seen any analysis of why that
> might be.  If it's just to use the disk system bandwith better, maybe
we should
> combine page writes instead or something.

It is usually the reads that need aid. Writes are fast on modern
disksystems since they are
cached.

I think the main effect is reduced OS overhead for the readahead
prediction logic and
reduced system call overhead.

Andreas


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

Предыдущее
От: "Zeugswetter Andreas ADI SD"
Дата:
Сообщение: Re: Potential to_char localization bug
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: ecpg_config.h not installed