Skip site navigation (1) Skip section navigation (2)

WAL performance with wal_sync_method = open_sync

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: WAL performance with wal_sync_method = open_sync
Date: 2001-04-28 12:15:28
Message-ID: 20010428211528H.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

I'm playing with wal parameters and found that wal_sync_method =
open_sync enormously enhance the performance on my machine. Without it
(using default fsync) I got only 90 tps at the best using pgbench (-s
2). However if I set wal_sync_method = open_sync, I get ~200 tps. I
have checked PostgreSQL uses O_SYNC flag when it opens WAL log files
using strace. Can anybody tell me why? I am afraid this is just a
dream:-) Linux kernel 2.2.17.
--
Tatsuo Ishii

Responses

pgsql-hackers by date

Next:From: Roberto MelloDate: 2001-04-28 14:55:32
Subject: Re: [HACKERS] Support for %TYPE in CREATE FUNCTION
Previous:From: Sergey E. VolkovDate: 2001-04-28 08:59:42
Subject: Re: WAL feature

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group