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 A66F79DC9F2 for ; Mon, 27 Feb 2006 21:14:12 -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 46764-09 for ; Mon, 27 Feb 2006 21:14:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from candle.pha.pa.us (candle.pha.pa.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id E26039DC9B7 for ; Mon, 27 Feb 2006 21:14:09 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id k1S1EAQ17159; Mon, 27 Feb 2006 20:14:10 -0500 (EST) From: Bruce Momjian Message-Id: <200602280114.k1S1EAQ17159@candle.pha.pa.us> Subject: Re: wal sync method In-Reply-To: <1141043359.1556.44.camel@pndsoft> To: Javier Somoza Date: Mon, 27 Feb 2006 20:14:10 -0500 (EST) CC: Evgeny Gridasov , pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.393 required=5 tests=[AWL=-1.107, RAZOR2_CF_RANGE_51_100=0.5, RAZOR2_CF_RANGE_E8_51_100=1.5, RAZOR2_CHECK=0.5] X-Spam-Score: 1.393 X-Spam-Level: * X-Archive-Number: 200602/425 X-Sequence-Number: 17411 Use whichever sync method is fastest for you. They are all reliable, except turning fsync off. --------------------------------------------------------------------------- Javier Somoza wrote: > > > > 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/ > > > > > > > > > -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +