| From: | Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Konstantin Knizhnik <knizhnik(at)garret(dot)ru>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Flush pgstats file during checkpoints |
| Date: | 2024-07-12 13:01:19 |
| Message-ID: | ZpEpHxi/5xnXjrUS@ip-10-97-1-34.eu-west-3.compute.internal |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On Fri, Jul 12, 2024 at 12:10:26PM +0000, Bertrand Drouvot wrote:
> Need to spend more time and thoughts on 0002+.
I think there is a corner case, say:
1. shutdown checkpoint at LSN1
2. startup->reads the stat file (contains LSN1)->all good->read stat file and
remove it
3. crash (no checkpoint occured between 2. and 3.)
4. startup (last checkpoint is still LSN1)->no stat file (as removed in 2.)
In that case we start with empty stats.
Instead of removing the stat file, should we keep it around until the first call
to pgstat_write_statsfile()?
Regards,
--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Dolgov | 2024-07-12 13:44:26 | Re: Pluggable cumulative statistics |
| Previous Message | Dean Rasheed | 2024-07-12 12:34:01 | Re: Optimize mul_var() for var1ndigits >= 8 |