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

Re: pgsql: Use O_DIRECT if available when using O_SYNC for wal_sync_method.

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Use O_DIRECT if available when using O_SYNC for wal_sync_method.
Date: 2005-07-29 06:41:13
Message-ID: dccj6r$1iun$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-committers
"Bruce Momjian" <momjian(at)svr1(dot)postgresql(dot)org> writes
> >             | writeback | fsync= | fdata | open_ | fsync_ | open_
> > patch       | cache     |  false |  sync |  sync | direct | direct
> > ------------+-----------+--------+-------+-------+--------+---------
> > direct io   | off       |  124.2 | 105.7 |  48.3 |   48.3 |  48.2
> > direct io   | on        |  129.1 | 112.3 | 114.1 |  142.9 | 144.5
> > gather-write| off       |  124.3 | 108.7 | 105.4 |  (N/A) | (N/A)
> > both        | off       |  131.5 | 115.5 | 114.4 |  145.4 | 145.2
> >

Can you explain the huge difference here:

>             | writeback |        |       | open_ |        |
> patch       | cache     |        |       |  sync |        |
> ------------+-----------+--------+-------+-------+--------+---------
> direct io   | off       |        |       |  48.3 |        |
> gather-write| off       |        |       | 105.4 |        |
> both        | off       |        |       | 114.4 |        |

Why both direct_io and gather_write is turned on but the open_sync
performance degrades?

Regards,
Qingqing



In response to

pgsql-committers by date

Next:From: Bruce MomjianDate: 2005-07-29 12:59:15
Subject: pgsql: Fix typo.
Previous:From: User LlonerganDate: 2005-07-29 06:29:47
Subject: bizgres - bizgres: Another name change.

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