On Thu, Jul 28, 2005 at 05:48:21PM -0500, Guy Rouillier wrote: > Jan Wieck wrote: > > > Then again, the stats file is only written. There is nothing that > > actually forces the blocks out. On a busy system, one individual stats > > file will be created, written to, renamed, live for 500ms and be > > thrown away by the next stat files rename operation. I would assume > > that with a decent filesystem and appropriate OS buffers, none of the > > data blocks of most stat files even hit the disk. I must be missing > > something. > > (From someone who is at best semi-informed).. Unless battery-backed > cache is available, we are advised to run with fsync enabled. Wouldn't > that affect the stats files as well? The stats file is dispensable. In fact, it has been proposed that on crash recovery the stat file should be deleted. -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) "Y eso te lo doy firmado con mis lágrimas" (Fiebre del Loco) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
