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

From Scott Marlowe
Subject Re: kernel version impact on PostgreSQL performance
Date
Msg-id dcc563d11003050950u6421da34pe7c684bd6727fbf3@mail.gmail.com
Whole thread Raw
In response to kernel version impact on PostgreSQL performance  (Cyril Scetbon <cscetbon.ext@orange-ftgroup.com>)
Responses Re: kernel version impact on PostgreSQL performance  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: G Dutton
Date:
Subject: log_statement and syslog severity
Next
From: John R Pierce
Date:
Subject: Re: kernel version impact on PostgreSQL performance