Re: Statistics Import and Export: difference in statistics dumped

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Statistics Import and Export: difference in statistics dumped
Дата
Msg-id 5053263e41692dc2358a642403e9aa6fcda53578.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: Statistics Import and Export: difference in statistics dumped  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Ответы Re: Statistics Import and Export: difference in statistics dumped
Список pgsql-hackers
On Fri, 2025-02-28 at 14:51 +0530, Ashutosh Bapat wrote:
> 2. We aren't restoring the statistics faithfully - as mentioned in
> Greg's reply. If users dump and restore with autovacuum turned off,
> they will be surprised to see the statistics to be different on the
> original and restored database - which may have other effects like
> change in plans.

Then let's just address that concern directly: disable updating stats
implicitly if autovacuum is off. If autovacuum is on, the user
shouldn't have an expectation of stable stats anyway. Patch attached.

Regards,
    Jeff Davis


Вложения

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