Обсуждение: Re: Support --include-analyze in pg_dump, pg_dumpall, pg_restore

Поиск
Список
Период
Сортировка

Re: Support --include-analyze in pg_dump, pg_dumpall, pg_restore

От
Tom Lane
Дата:
jian he <jian.universality@gmail.com> writes:
> the implemented feature is as the $subject description, making pg_dump
> also includes the ANALYZE command in its output.

Isn't this pretty much obsoleted by the ongoing work to dump and
restore statistics?

            regards, tom lane



Re: Support --include-analyze in pg_dump, pg_dumpall, pg_restore

От
Nathan Bossart
Дата:
On Tue, Jan 14, 2025 at 09:32:19AM -0500, Tom Lane wrote:
> jian he <jian.universality@gmail.com> writes:
>> the implemented feature is as the $subject description, making pg_dump
>> also includes the ANALYZE command in its output.
> 
> Isn't this pretty much obsoleted by the ongoing work to dump and
> restore statistics?

Yeah, and I believe that work is still on track for v18.  That's likely
going to be much faster than analyzing everything, and it'll be usable in
pg_upgrade, too.

    https://postgr.es/m/flat/CADkLM%3DcB0rF3p_FuWRTMSV0983ihTRpsH%2BOCpNyiqE7Wk0vUWA%40mail.gmail.com

-- 
nathan