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

Re: Configuring fdatasync for Solaris2

From: sugita(at)srapc1267(dot)sra(dot)co(dot)jp
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Configuring fdatasync for Solaris2
Date: 2001-09-12 17:14:10
Message-ID: 20010912171411.04F488AB8E@srapc1267.sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-patches
Date: Thu, 13 Sep 2001 01:37:31 +0900
From: Kenji Sugita <sugita(at)sranhm(dot)sra(dot)co(dot)jp>

> Date: Wed, 12 Sep 2001 14:19:09 +0200 (CEST)
> From: Peter Eisentraut <peter_e(at)gmx(dot)net>
> To: Kenji Sugita <sugita(at)sra(dot)co(dot)jp>
> Subject: Re: [PATCHES] Configuring fdatasync for Solaris2
> 
> > I also cannot find out the rt library on Solaris2. The library posix4 hits
> > fdatasync.
> 
> I rechecked the manuals, apparently -lrt was added in a later version
> (after the POSIX.4 group was renamed?).  I've changed the test to check
> both libraries.

Thanks a lot.

> Do you have any performance data of the fdatasync method versus the
> default open_datasync method?

I have the data for SPARC 500MHz Solaris2.6 running PostgreSQL 7.1.3.

    #clients  open_datasync  fdatasync (TPC-B, TPS)
    ========  =============  =========
    1             34.867522  47.188265
    2             41.457329  57.119142
    4             41.854741  62.250403
    8             43.103382  63.909396
    16            35.890254  62.757908
    32            41.421592  52.132258
    64            37.325511  51.805046
    128           28.906521  37.942672

This table is made by following commands:

    pgbench -i -s 10 
    pgbench -c #clients -t 100

> Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter


Kenji Sugita                                      
sugita(at)sra(dot)co(dot)jp

pgsql-patches by date

Next:From: Kenji SugitaDate: 2001-09-12 18:07:29
Subject: Re: Configuring fdatasync for Solaris2
Previous:From: Kenji SugitaDate: 2001-09-12 16:37:31
Subject: Re: Configuring fdatasync for Solaris2

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