| From: | ZizhuanLiu X-MAN <44973863(at)qq(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Cc: | Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, tgl <tgl(at)sss(dot)pgh(dot)pa(dot)us>, tomas <tomas(at)vondra(dot)me>, dean(dot)a(dot)rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, guofenglinux <guofenglinux(at)gmail(dot)com> |
| Subject: | Re: Optimize MCV stats for sortable types and utilize sorted-order properties |
| Date: | 2026-10-08 15:27:56 |
| Message-ID: | tencent_FCC277B561D0BE4E107FBB581E517336260A@qq.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Previous versions also modified import_fetched_statistics()->import_attribute_statistics()
by adding the most_common_vals_kind parameter.
However, when analyzing a PostgreSQL FDW, for example with ANALYZE simport_ftable;
in contrib/postgres_fdw/sql/postgres_fdw.sql, fetch_attstats() did not retrieve the
corresponding MCV kind to pass to the newly added most_common_vals_kind parameter.
This issue is now fixed.
regards,
--
ZizhuanLiu (X-MAN)
44973863(at)qq(dot)com
| Attachment | Content-Type | Size |
|---|---|---|
| v11-0001-Optimize-MCV-statistics-for-sortable-types.patch | application/octet-stream | 149.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2026-10-08 15:41:26 | Re: Adding init-po and update-po targets to the meson build system |
| Previous Message | Jacob Champion | 2026-10-08 15:15:39 | Re: Adding init-po and update-po targets to the meson build system |