Re: Statistics Import and Export
От
Bruce Momjian
Тема
Re: Statistics Import and Export
Дата
Msg-id
Z0cyU15g7x0TrGd9@momjian.us
Ответ на
Re: Statistics Import and Export (Magnus Hagander)
Список
Дерево обсуждения
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 Wed, Nov 27, 2024 at 02:44:01PM +0100, Magnus Hagander wrote: > If you want to avoid both the surprise and confusion factor mentioned before, > maybe what's needed is to *remove* --analyze-in-stages, and replace it with > --analyze-missing-in-stages and --analyze-all-in-stages (with the clear warning > about what --analyze-all-in-stages can do to your system if you already have > statistics). > > That goes with the "immediate breakage that you see right away is better than > silently doing the unexpected where you might not notice the problem until much > later". > > That might trade some of that surprise and confusion for annoyance instead, but > going forward that might be a clearer path? Oh, so remove --analyze-in-stages and have it issue a suggestion, and make two versions --- yeah, that would work too. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com When a patient asks the doctor, "Am I going to die?", he means "Am I going to die soon?"
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата: