| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | Zhihong Yu <zyu(at)yugabyte(dot)com>, Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: extended stats on partitioned tables |
| Date: | 2022-01-15 05:11:38 |
| Message-ID: | 20220115051138.GR14051@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Dec 13, 2021 at 09:40:09PM +0100, Tomas Vondra wrote:
> 1) If the table is a separate relation (not part of an inheritance
> tree), this should make no difference. -> OK
>
> 2) If the table is using "old" inheritance, this reverts back to
> pre-regression behavior. So people will keep using the old statistics
> until the ANALYZE, and we need to tell them to ANALYZE or something.
>
> 3) If the table is using partitioning, it's guaranteed to be empty and
> there are no stats at all. Again, we should tell people to run ANALYZE.
I think these can be mentioned in the commit message, which can end up in the
minor release notes as a recommendation to rerun ANALYZE.
Thanks for pushing 0001.
--
Justin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2022-01-15 05:12:08 | Re: sequences vs. synchronous replication |
| Previous Message | Julien Rouhaud | 2022-01-15 04:42:30 | Re: Support for NSS as a libpq TLS backend |