| 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 |