X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 34EB59DC825 for ; Mon, 27 Feb 2006 08:28:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10163-10 for ; Mon, 27 Feb 2006 08:28:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bilbao.pandasoftware.es (unknown [62.14.249.71]) by postgresql.org (Postfix) with ESMTP id 06F789DC81A for ; Mon, 27 Feb 2006 08:28:36 -0400 (AST) Received: from escorpexh05.pandasoftware.local (escorpext02 [192.168.100.182]) by bilbao.pandasoftware.es (Postfix) with ESMTP id C71BE1B382E; Mon, 27 Feb 2006 13:28:16 +0100 (CET) Received: from ESCORPEXH03.pandasoftware.local ([172.16.0.70]) by escorpexh05.pandasoftware.local with Microsoft SMTPSVC(6.0.3790.211); Mon, 27 Feb 2006 13:28:35 +0100 Received: escorpexh03.pandasoftware.local 172.16.0.73 from 172.16.128.4 172.16.128.4 via HTTP with MS-WebStorage 6.5.6944 Received: from pndsoft by escorpexh03.pandasoftware.local; 27 Feb 2006 13:29:19 +0100 Subject: Re: wal sync method From: Javier Somoza To: Evgeny Gridasov Cc: pgsql-performance@postgresql.org In-Reply-To: <20060227150819.48e48a85.eugrid@fpm.kubsu.ru> References: <1128015863.11474.9.camel@noodles> <5709.1128146518@sss.pgh.pa.us> <20060227150819.48e48a85.eugrid@fpm.kubsu.ru> Content-Type: multipart/alternative; boundary="=-h+pnIo7DFRbKVIrlmZMe" Message-Id: <1141043359.1556.44.camel@pndsoft> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Mon, 27 Feb 2006 13:29:19 +0100 X-OriginalArrivalTime: 27 Feb 2006 12:28:35.0832 (UTC) FILETIME=[54610F80:01C63B99] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.582 required=5 tests=[AWL=0.080, HTML_MESSAGE=0.001, RAZOR2_CF_RANGE_51_100=0.5, RAZOR2_CF_RANGE_E8_51_100=1.5, RAZOR2_CHECK=0.5, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 2.582 X-Spam-Level: ** X-Archive-Number: 200602/412 X-Sequence-Number: 17398 --=-h+pnIo7DFRbKVIrlmZMe Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi Evgeny Im also testing what fsync method to use and using this program (http://archives.postgresql.org/pgsql-performance/2003-12/msg00191.php) a bit modified and i get this results: write 0.000036 write & fsync 0.006796 write & fdatasync 0.001001 write (O_FSYNC) 0.005761 write (O_DSYNC) 0.005894 So fdatasync faster for me?=20 > Hi everybody! >=20 > Which wal sync method is the fastest under linux 2.6.x? > I'm using RAID-10 (JFS filesystem), 2xXEON, 4 Gb RAM. >=20 > I've tried to switch to open_sync which seems to work=20 > faster than default fdatasync, but is it crash-safe? Javier Somoza Oficina de Direcci=F3n Estrat=E9gica mailto:jsomoza@pandasoftware.es Panda Software Buenos Aires, 12 48001 BILBAO - ESPA=D1A Tel=E9fono: 902 24 365 4 Fax: 94 424 46 97 http://www.pandasoftware.es Panda Software, una de las principales compa=F1=EDas desarrolladoras de soluciones de protecci=F3n contra virus e intrusos, presenta su nueva familia de soluciones. Todos los usuarios de ordenadores, desde las redes m=E1s grandes a los dom=E9sticos, disponen ahora de nuevos productos con excelentes tecnolog=EDas de seguridad. M=E1s informaci=F3n en: http://www.pandasoftware.es/productos =20 =A1Prot=E9jase ahora contra virus e intrusos! Pruebe gratis nuestros productos en http://www.pandasoftware.es/descargas/ =20 =20 =20 =20 =20 =20 =20 =20 --=-h+pnIo7DFRbKVIrlmZMe Content-Type: text/html; charset=utf-8


        Hi Evgeny

        Im also testing what fsync method to use and using this program (http://archives.postgresql.org/pgsql-performance/2003-12/msg00191.php)
        a bit modified and i get this results:

                write                          0.000036
                write & fsync             0.006796
                write & fdatasync      0.001001
                write (O_FSYNC)        0.005761
                write (O_DSYNC)        0.005894

        So fdatasync faster for me? 

Hi everybody!

Which wal sync method is the fastest under linux 2.6.x?
I'm using RAID-10 (JFS filesystem), 2xXEON, 4 Gb RAM.

I've tried to switch to open_sync which seems to work 
faster than default fdatasync, but is it crash-safe?






Javier Somoza

Oficina de Dirección Estratégica

mailto:jsomoza@pandasoftware.es



Panda Software

Buenos Aires, 12

48001 BILBAO - ESPAÑA

Teléfono: 902 24 365 4

Fax:  94 424 46 97

http://www.pandasoftware.es

Panda Software, una de las principales compañías desarrolladoras de soluciones de protección contra virus e intrusos, presenta su nueva familia de soluciones. Todos los usuarios de ordenadores, desde las redes más grandes a los domésticos, disponen ahora de nuevos productos con excelentes tecnologías de seguridad. Más información en: http://www.pandasoftware.es/productos

    
    
    


¡Protéjase ahora contra virus e intrusos! Pruebe gratis nuestros productos en http://www.pandasoftware.es/descargas/
--=-h+pnIo7DFRbKVIrlmZMe--