From: Javier Somoza <jsomoza@pandasoftware.es>
To: Evgeny Gridasov <eugrid@fpm.kubsu.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: wal sync method
Date: Mon, 27 Feb 2006 13:29:19 +0100
Message-ID: <1141043359.1556.44.camel@pndsoft> (raw)
In-Reply-To: <20060227150819.48e48a85.eugrid@fpm.kubsu.ru>
References: <BF616D3C.104C3%llonergan@greenplum.com>
<1128015863.11474.9.camel@noodles>
<5709.1128146518@sss.pgh.pa.us>
<20060227150819.48e48a85.eugrid@fpm.kubsu.ru>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jsomoza@pandasoftware.es, eugrid@fpm.kubsu.ru
Subject: Re: wal sync method
In-Reply-To: <1141043359.1556.44.camel@pndsoft>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox