On Friday, May 25, 2012 05:19:28 PM Tom Lane wrote:
> Andres Freund <andres@2ndquadrant.com> writes:
> > On Friday, May 25, 2012 04:03:49 PM Peter Geoghegan wrote:
> >> Where do you suggest the file be written to?
> >
> > One could argue stats_temp_directory would be the correct place.
>
> No, that would be exactly the *wrong* place, because that directory can
> be on a RAM disk. We need to put this somewhere where it'll survive
> a shutdown.
I had assumed it would do the writeout regularly to survive a database crash.
As it does not do that my argument is clearly bogus, sorry for that.
Andres
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services