Re: kernel version impact on PostgreSQL performance

Scott Marlowe wrote:
> On Fri, Mar 5, 2010 at 7:09 AM, Cyril Scetbon
> <cscetbon.ext@orange-ftgroup.com> wrote:
>
>> Does anyone know what can be the differences between linux kernels 2.6.29
>> and 2.6.30 that can cause this big difference (TPS x 7 !)
>> http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2
>>
>
> I'm gonna guess those ones with huge TPC B throughput weren't properly
> fsyncing their data to the disks.  to get that high of a number
> requires a disk subsystem that can commit 1300 or so changes a second,
> which a single disk can't really do.
>
>


indeed, that was my first thought too.   being on the trailing edge of
kernel builds (I mostly run CentOS4 and 5, and most our more important
servers are Solaris based), I can only view this with some amusement.