Re: The results of my PostgreSQL/filesystem performance tests - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: The results of my PostgreSQL/filesystem performance tests
Date
Msg-id 082e01c36dd1$3bf1f150$2800a8c0@mars
Whole thread Raw
In response to The results of my PostgreSQL/filesystem performance tests  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: The results of my PostgreSQL/filesystem performance tests  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: The results of my PostgreSQL/filesystem performance
Next
From: Vivek Khera
Date:
Subject: Re: opinion on RAID choice