On Fri, May 25, 2012 at 6:49 PM, Josh Berkus <j...@agliodbs.com> wrote: > On 5/25/12 8:19 AM, Tom Lane wrote: >> Andres Freund <and...@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. > > 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/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers