Re: Statistics Import and Export

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: Statistics Import and Export
Дата
Msg-id
6d1c72b06fe3645a50897381d71ff1b39085abf6.camel@j-davis.com
Ответ на
Список
Дерево обсуждения
Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Statistics Import and Export Shubham Khanna <khannashubham1197@gmail.com>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Bruce Momjian <bruce@momjian.us>
Re: Statistics Import and Export Bruce Momjian <bruce@momjian.us>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Bruce Momjian <bruce@momjian.us>
Re: Statistics Import and Export Bruce Momjian <bruce@momjian.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Andrei Lepikhov <a.lepikhov@postgrespro.ru>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Peter Smith <smithpb2250@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Nathan Bossart <nathandbossart@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Magnus Hagander <magnus@hagander.net>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Bruce Momjian <bruce@momjian.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Nathan Bossart <nathandbossart@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Bruce Momjian <bruce@momjian.us>
Re: Statistics Import and Export Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Bruce Momjian <bruce@momjian.us>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Michael Paquier <michael@paquier.xyz>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Statistics Import and Export Stephen Frost <sfrost@snowman.net>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Jeff Davis <pgsql@j-davis.com>
Re: Statistics Import and Export Tom Lane <tgl@sss.pgh.pa.us>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Statistics Import and Export Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Statistics Import and Export Corey Huinker <corey.huinker@gmail.com>
Re: Statistics Import and Export Tomas Vondra <tomas.vondra@enterprisedb.com>
On Mon, 2025-02-24 at 13:47 -0500, Corey Huinker wrote:
> There doesn't seem to be any way around it, but it will
> slightly complicate the dump-ing side of things, in that we need to
> either:
> 
> a) switch to attnums for index expressions and keep attname calls for
> everything else.

The only stats for indexes are on expression columns, so AFAICT there's
no difference between the above description and "use attnums for
indexes and attnames for tables". Either way, I agree that's the way to
go.

We certainly want attnames for tables to keep it working reasonably
well for cases where the user might be doing something more interesting
than a binary upgrade, as you point out. But attribute numbers for
indexes seem much more reliable: an index with a different attribute
order is a fundamentally different index.

Regards,
	Jeff Davis



В списке pgsql-hackers по дате отправления
От: Corey Huinker
Дата:
От: Corey Huinker
Дата:
FAQ