Re: [PATCHES] WAL: O_DIRECT and multipage-writer (+

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: Mark Wong <markw(at)osdl(dot)org>, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] WAL: O_DIRECT and multipage-writer (+
Date: 2005-03-11 09:55:35
Message-ID: 1110534935.6117.472.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Tue, 2005-03-01 at 13:53 -0800, Mark Wong wrote:
> On Thu, Feb 03, 2005 at 07:25:55PM +0900, ITAGAKI Takahiro wrote:
> > Hello everyone.
> >
> > I fixed two bugs in the patch that I sent before.
> > Check and test new one, please.
>
> Ok, finally got back into the office and was able to run 1 set of
> tests.
>
> So the new baseline result with 8.0.1:
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/309/
> Throughput: 3639.97
>
> Results with the patch but open_direct not set:
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/308/
> Throughput: 3494.72
>
> Results with the patch and open_direct set:
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/312/
> Throughput: 3489.69
>
> You can verify that the wall_sync_method is set to open_direct under
> the "database parameters" link, but I'm wondering if I missed
> something. It looks a little odd the the performance dropped.

Is there anything more to say on this?
Is it case-closed, or is there further work underway - I can't see any
further chat on this thread.

These results show it doesn't work better on larger systems. The
original testing showed it worked better on smaller systems - is there
still scope to include this for smaller configs?

If not, thanks for taking the time to write the patch and investigate
whether changes in this area would help. Not every performance patch
improves things, but that doesn't mean we shouldn't try...

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Milen A. Radev 2005-03-11 10:06:16 Re: Too frequent warnings for wraparound failure
Previous Message Thomas Hallgren 2005-03-11 09:53:54 Re: Runtime accepting build discrepancies

Browse pgsql-patches by date

  From Date Subject
Next Message Marko Kreen 2005-03-11 15:48:30 pgcrypto: openssl digest fix
Previous Message Nicolai Tufar 2005-03-11 06:41:39 Re: [pgsql-hackers-win32] snprintf causes regression tests to fail