| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, John Naylor <johncnaylorls(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "alvherre(at)alvh(dot)no-ip(dot)org" <alvherre(at)alvh(dot)no-ip(dot)org> |
| Subject: | Re: vacuumdb changes for stats import/export |
| Date: | 2025-07-28 18:34:11 |
| Message-ID: | aIfCo9q_L-VHO624@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jul 28, 2025 at 09:22:29AM -0700, David G. Johnston wrote:
> Makes sense. This does beg the question - what happens if a column is left
> with a lower statistics target than what would be applied during an
> analyze, but one is present? I don´t see where the statistics target is
> saved anywhere. Can we start recording that piece of data and teach
> analyze in stages to just never go backwards - reporting any it had to skip
> to adhere to that rule. Seems like a better policy than missing-only.
That would involve changing the behavior of an existing option, which has
thus far been strongly opposed [0], for what strikes me as a reasonably
uncommon situation. Plus, --missing-stats-only may be useful in other
situations.
[0] https://postgr.es/m/Z6KKHX9PZkB19lAK%40nathan
--
nathan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2025-07-28 18:37:59 | Re: Doc update proposal for the note on log_statement in the runtime config for logging page |
| Previous Message | Tom Lane | 2025-07-28 18:28:43 | Re: Regression with large XML data input |