From:
Mark Wong <markw(at)osdl(dot)org>
To:
ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
Cc:
pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject:
Re: [PATCHES] WAL: O_DIRECT and multipage-writer (+ memory leak)
Date:
2005-03-01 21:53:10
Message-ID:
20050301215310.GD2115@osdl.org (view raw or flat )
Thread:
2005-01-25 09:06:23 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
2005-01-25 09:30:01 from "Michael Paesold" <mpaesold(at)gmx(dot)at>
2005-01-25 10:33:40 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
2005-01-25 15:56:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-01-26 13:06:46 from ITAGAKI Takahiro <itagaki(at)tiara(dot)ocn(dot)ne(dot)jp>
2005-01-27 18:18:44 from Mark Wong <markw(at)osdl(dot)org>
2005-01-27 21:28:32 from ITAGAKI Takahiro <itagaki(at)tiara(dot)ocn(dot)ne(dot)jp>
2005-01-27 21:30:25 from Mark Wong <markw(at)osdl(dot)org>
2005-02-03 10:25:55 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
2005-02-15 04:08:18 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-03-01 21:53:10 from Mark Wong <markw(at)osdl(dot)org>
2005-03-11 09:55:35 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2005-06-05 03:42:51 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-05 03:40:48 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-05 04:45:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-06 13:35:54 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-06-06 13:56:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2005-06-06 06:53:27 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
2005-02-14 23:25:04 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2005-03-22 22:30:13 from Mark Wong <markw(at)osdl(dot)org>
2005-03-23 04:55:46 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
2005-03-23 23:59:20 from Mark Wong <markw(at)osdl(dot)org>
Lists:
pgsql-hackers pgsql-patches
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.
Mark
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2005-03-01 21:57:11Subject : Re: 8.0.X and the ARC patent Previous :From : Mark WongDate : 2005-03-01 21:51:16Subject : Re: 8.0.X and the ARC patent
pgsql-patches by date
Next :From: Tom LaneDate: 2005-03-01 22:45:31Subject : Re: [pgsql-hackers-win32] snprintf causes regression tests to fail Previous :From : Magnus HaganderDate : 2005-03-01 20:08:27Subject : Getting rid of the global timezone
