Re: Autovacuum giving up on tables after crash because of lack of stats - Mailing list pgsql-hackers

From Bertrand Drouvot
Subject Re: Autovacuum giving up on tables after crash because of lack of stats
Date
Msg-id Z3Oi7uyDsL9KymhQ@ip-10-97-1-34.eu-west-3.compute.internal
Whole thread Raw
In response to Re: Autovacuum giving up on tables after crash because of lack of stats  (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>)
List pgsql-hackers
Hi,

On Mon, Dec 30, 2024 at 07:12:54PM +0900, Michael Paquier wrote:
> 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.

Thanks, will look at it!

> And Happy New Year to all!  In advance.

Happy New Year to you too!

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com



pgsql-hackers by date:

Previous
From: wenhui qiu
Date:
Subject: Re: add vacuum starttime columns
Next
From: Srirama Kucherlapati
Date:
Subject: RE: AIX support