Re: Statistics Import and Export
От
Jeff Davis
Тема
Re: Statistics Import and Export
Дата
Msg-id
6d1c72b06fe3645a50897381d71ff1b39085abf6.camel@j-davis.com
Ответ на
Re: Statistics Import and Export (Corey Huinker)
Список
Дерево обсуждения
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 по дате отправления