Re: Autovacuum giving up on tables after crash because of lack of stats

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Autovacuum giving up on tables after crash because of lack of stats
Дата
Msg-id mslmwxe44d2fypy6q3ulytpojyrx6cbxhvnu47pyqynwvsp7t6@afwcncaqkmmc
обсуждение исходный текст
Ответ на Re: Autovacuum giving up on tables after crash because of lack of stats  (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>)
Ответы Re: Autovacuum giving up on tables after crash because of lack of stats
Список pgsql-hackers
On 2024-12-30 19:12:54 +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.

Good then that I was not at all proposing to only flush the stats at redo?

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления: