Re: pg_stat_statements temporary file

On Fri, May 25, 2012 at 6:49 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> On 5/25/12 8:19 AM, Tom Lane wrote:
>> Andres Freund <andres(at)2ndquadrant(dot)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.
>
> Mind you, I can imagine a busy system wanting to keep PSS on a ram disk
> as well. But users should be able to make that decision separately from
> the stats file.

Why would they want that? PSS only writes the tempfile on shutdown and
reads it on startup. Unlike pgstats which reads and writes it all the
time.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/