On Wed, Jun 19, 2013 at 5:32 AM, Sameer Thakur <samthakur74@gmail.com> wrote:
> If there is a crash i understand that pg_stat_statements.stat file is not
> created even if pg_stat_statements.save=true.
> If the crash happened before pg_stat_statements.stat file is deleted then,
> on recovery, is that pg_stat_statements.stat file deleted?
> On crash recovery, are statement statistics reset ,to same values as would
> be the case on normal startup in the case pg_stat_statements.save=false?
The pg_stat_statements statistics file is just deleted when the server
starts, and statistics are serialized to disk when there's a clean
shutdown. pg_stat_statements is similar to the statistics collector
here.
Why are you posting this to the -performance list?
--
Regards,
Peter Geoghegan