Re: The results of my PostgreSQL/filesystem performance tests

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: The results of my PostgreSQL/filesystem performance tests
Дата
Msg-id 082e01c36dd1$3bf1f150$2800a8c0@mars
обсуждение исходный текст
Ответ на The results of my PostgreSQL/filesystem performance tests  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: The results of my PostgreSQL/filesystem performance tests  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-performance
> I'm likely going to make this the default for PostgreSQL on FreeBSD
> starting with 7.4 (just posted something to -hackers about this)f.  If
> you'd like to do this in your testing, just apply the following patch.
>
> Right now PostgreSQL defaults to 8K blocks, but FreeBSD uses 16K
> blocks which means that currently, reading two blocks of data in PG is
> two read calls to the OS, one reads 16K of data off disk and returns
> the 1st page, the 2nd call pulls the 2nd block from the FS cache.  In
> making things 16K, it avoids the need for the 2nd system call which is
> where the performance difference is coming from, afaikt.  -sc

Are you _sure_ this won't cause any atomicity problems?  Can FreeBSD write
16k as an atomic unit?

Chris


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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: The results of my PostgreSQL/filesystem performance
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: opinion on RAID choice