| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com> |
| Cc: | Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Autovacuum giving up on tables after crash because of lack of stats |
| Date: | 2024-12-30 10:12:54 |
| Message-ID: | Z3JyJvDezNsPHwkF@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Dec 30, 2024 at 09:44:45AM +0000, Bertrand Drouvot wrote:
> I think that replicating stats that are used by autovacuum would be an additional
> benefit, so +1 for the idea number 2). This is an "issue" that has been raised
> multiple times (like in [1]).
>
> [1]: https://www.postgresql.org/message-id/20240607033806.6gwgolihss72cj6r%40awork3.anarazel.de
Yeah, I recall reading this one. A colleague has poked me about doing
something here a few weeks ago, as well, and only flushing the stats
at redo was not enough while being full of holes.
Attached is a rebase, following b757abefc041, for the moment.
And Happy New Year to all! In advance.
--
Michael
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Move-information-about-pgstats-kinds-into-its-own.patch | text/x-diff | 5.7 KB |
| v2-0002-Add-RMGR-and-WAL-logging-API-for-pgstats.patch | text/x-diff | 11.2 KB |
| v2-0003-injection_points-Add-option-and-tests-for-WAL-log.patch | text/x-diff | 7.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vignesh C | 2024-12-30 10:33:23 | Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size |
| Previous Message | vignesh C | 2024-12-30 10:10:14 | Re: Logical Replication of sequences |