Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: fsync and battery-backed caches
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: Tino Wildenhain <tino(at)wildenhain(dot)de>
- Cc: Javier Somoza <jsomoza(at)pandasoftware(dot)es>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: fsync and battery-backed caches
- Date: Mon, 27 Feb 2006 18:22:23 -0600
On Mon, Feb 27, 2006 at 11:12:57AM +0100, Tino Wildenhain wrote: > Javier Somoza schrieb: > > > > Hi all > > > > Is it secure to disable fsync havin battery-backed disk cache? > > > > Thx > > > No. fsync moves the data from OS memory cache to disk-adaptor > cache which is required to benefit from battery backup. More importantly, in guarantees that data is committed to non-volatile storage in such a way that PostgreSQL can recover from a crash without corruption. If you have a battery-backed controller and turn on write caching you shouldn't see much effect from fsync anyway. -- Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- Follow-Ups:
- Re: fsync and battery-backed caches
- From: Bruce Momjian
- Re: fsync and battery-backed caches
- References:
- fsync and battery-backed caches
- From: Javier Somoza
- Re: fsync and battery-backed caches
- From: Tino Wildenhain
- fsync and battery-backed caches
- Prev by Date: Re: Large Table With Only a Few Rows
- Next by Date: Re: fsync and battery-backed caches
- Previous by thread: Re: fsync and battery-backed caches
- Next by thread: Re: fsync and battery-backed caches
- Indexes: