| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Cyril Scetbon <cscetbon(dot)ext(at)orange-ftgroup(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: kernel version impact on PostgreSQL performance |
| Date: | 2010-03-05 17:58:44 |
| Message-ID: | 4B914654.8040406@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Marlowe wrote:
> On Fri, Mar 5, 2010 at 7:09 AM, Cyril Scetbon
> <cscetbon(dot)ext(at)orange-ftgroup(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mridula Mahadevan | 2010-03-05 18:12:34 | Re: Foreign key behavior different in a function and outside |
| Previous Message | Scott Marlowe | 2010-03-05 17:50:22 | Re: kernel version impact on PostgreSQL performance |