pg_stat_statements behavior in crash recovery

From: Sameer Thakur <samthakur74(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: pg_stat_statements behavior in crash recovery
Date: 2013-06-19 12:32:45
Message-ID: CABzZFEvZiUB7iMgn=Dj7-RJ9KDTVHmcCPKy-n8wWZzufA4b8zg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,
I understand that when the pg_stat_statements.save=true the
statement statistics are saved at global/pg_stat_statements.stat. This file
is read on next startup and then deleted.
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?
Thank you
Sameer

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Geoghegan 2013-06-19 14:24:45 Re: pg_stat_statements behavior in crash recovery
Previous Message Sameer Thakur 2013-06-19 10:59:38 Re: pg_stat_statements query normalization