Re: Statistics Import and Export
От
Jeff Davis
Тема
Re: Statistics Import and Export
Дата
Msg-id
57e2d0c87d30e9b0dfb80f5b5d6a1a82a2539f10.camel@j-davis.com
Ответ на
Re: Statistics Import and Export (Tom Lane)
Список
Дерево обсуждения
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 Sat, 2024-03-30 at 20:08 -0400, Tom Lane wrote: > I haven't looked at the details, but I'm really a bit surprised > by Jeff's assertion that CREATE INDEX destroys statistics on the > base table. That seems wrong from here, and maybe something we > could have it not do. (I do realize that it recalculates reltuples > and relpages, but so what? If it updates those, the results should > be perfectly accurate.) In the v15 of the patch I was looking at, "pg_dump -s" included the statistics. The stats appeared first in the dump, followed by the CREATE INDEX commands. The latter overwrote the relpages/reltuples set by the former. While zeros are the right answers for a schema-only dump, it defeated the purpose of including relpages/reltuples stats in the dump, and caused the pg_upgrade TAP test to fail. You're right that there are a number of ways this could be resolved -- I don't think it's an inherent problem. Regards, Jeff Davis
В списке pgsql-hackers по дате отправления
