Re: pg_stat_statements temporary file - Mailing list pgsql-hackers

From Andres Freund
Subject Re: pg_stat_statements temporary file
Date
Msg-id 201205281314.53013.andres@2ndquadrant.com
Whole thread Raw
In response to Re: pg_stat_statements temporary file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Backends stalled in 'startup' state: index corruption
Next
From: Florian Pflug
Date:
Subject: Re: [RFC] Interface of Row Level Security