Re: Statistics Import and Export

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: Statistics Import and Export
Дата
Msg-id
Z0cyU15g7x0TrGd9@momjian.us
Ответ на
Список
Дерево обсуждения
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
Дата:
От: Alvaro Herrera
Дата:
FAQ