Re: pg_stat_statements temporary file

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