Re: kernel version impact on PostgreSQL performance - Mailing list pgsql-general

From John R Pierce
Subject Re: kernel version impact on PostgreSQL performance
Date
Msg-id 4B914654.8040406@hogranch.com
Whole thread Raw
In response to Re: kernel version impact on PostgreSQL performance  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: kernel version impact on PostgreSQL performance
Next
From: Mridula Mahadevan
Date:
Subject: Re: Foreign key behavior different in a function and outside