From: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> |
---|---|
To: | Sameer Thakur <samthakur74(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: pg_stat_statements behavior in crash recovery |
Date: | 2013-06-19 14:24:45 |
Message-ID: | CAEYLb_WtKbNvhoMRSxqfo8A31JOU+uigr-tk1LNg_JQMfDYJCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Wed, Jun 19, 2013 at 5:32 AM, Sameer Thakur <samthakur74(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Sameer Thakur | 2013-06-20 04:04:13 | Re: pg_stat_statements behavior in crash recovery |
Previous Message | Sameer Thakur | 2013-06-19 12:32:45 | pg_stat_statements behavior in crash recovery |