On Wed, Jun 19, 2013 at 5:32 AM, Sameer Thakur <samthaku...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
