Re: RFE: Make statistics robust for unplanned events

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: RFE: Make statistics robust for unplanned events
Дата
Msg-id CAH2-WzkxhUBpVyQompg=iG1=SQpMxRiZ7f0AyJupOmdoojeUtA@mail.gmail.com
обсуждение исходный текст
Ответ на RFE: Make statistics robust for unplanned events  (Patrik Novotny <panovotn@redhat.com>)
Список pgsql-hackers
On Tue, Apr 20, 2021 at 5:00 AM Patrik Novotny <panovotn@redhat.com> wrote:
> As far as I've checked, this would have to be implemented.
>
> My question would be whether there is something that would make this impossible to implement, and if there isn't, I'd
likethis to be considered a feature request.
 

I agree with you.

Maybe crash safety would require some care in cases where autovacuum
runs very frequently, so that the overhead isn't too high. But
overall, non-crash-safe information that drives autovacuum is penny
wise, pound foolish.

I'm sure that it doesn't matter that much most of the time, but there
are probably workloads and use cases where it causes significant and
persistent problems. That's not the right trade-off IMV.

-- 
Peter Geoghegan



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

Предыдущее
От: SATYANARAYANA NARLAPURAM
Дата:
Сообщение: Re: Synchronous commit behavior during network outage
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: ML-based indexing ("The Case for Learned Index Structures", a paper from Google)