| From: | shihao zhong <zhong950419(at)gmail(dot)com> |
|---|---|
| To: | Andrew Krylosov <krylosov(dot)andrew(at)gmail(dot)com> |
| Cc: | Andrei Lepikhov <lepihov(at)gmail(dot)com>, Priyanka S <developerette(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [PATCH] Planner support function for generate_subscripts() |
| Date: | 2026-09-27 15:54:48 |
| Message-ID: | CAGRkXqTwM=54cqFZrYB9DJY5LwCVXE0pg_ATrBj23+kMS7yAnA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Andrew,
Thanks for testing and for the review. You're right. From statistics,
estimate_array_length() counts only distinct non-null elements, so the
estimate can also be too low.
v5 rewords that comment.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| v5-0002-Lower-generate_subscripts-s-prorows-estimate-to-1.patch | application/octet-stream | 3.6 KB |
| v5-0001-Add-a-planner-support-function-for-generate_subsc.patch | application/octet-stream | 20.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shihao zhong | 2026-09-27 16:02:56 | Re: Return pg_control from pg_backup_stop(). |
| Previous Message | shihao zhong | 2026-09-27 15:53:36 | Re: REPACK (CONCURRENTLY) can't complete after ~105M concurrent updates/deletes |