Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
Re: wal sync method
- From: Javier Somoza <jsomoza(at)pandasoftware(dot)es>
- To: Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: wal sync method
- Date: Mon, 27 Feb 2006 13:29:19 +0100
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(at)pandasoftware(dot)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 |
- Follow-Ups:
- Re: wal sync method
- From: Bruce Momjian
- Re: wal sync method
- References:
- wal sync method
- From: Evgeny Gridasov
- wal sync method
- Prev by Date: wal sync method
- Next by Date: Setting the shared buffers
- Previous by thread: wal sync method
- Next by thread: Re: wal sync method
- Indexes: