| From: | shihao zhong <zhong950419(at)gmail(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Add planner support function to two-argument regexp_like() |
| Date: | 2026-11-21 17:44:51 |
| Message-ID: | CAGRkXqRx3uDKrXsdYgLVOgR_uVQMMjt0g_0q3CC946x2PVLi7Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Fujii-san,
Thanks, good catch.
0001 in v4 makes starts_with() and the LIKE and regex functions use
statistics on the call. 0002 is the regexp_like() patch on top. Your
example now estimates 8000 rows. Operators are unchanged. Both are
master only.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Use-statistics-on-the-call-for-pattern-matching-func.patch | application/octet-stream | 4.4 KB |
| v4-0002-Add-planner-support-function-to-two-argument-regexp_.patch | application/octet-stream | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shihao zhong | 2026-11-21 17:47:08 | Re: Checkpoints stuck after a failed bulk write inside a savepoint |
| Previous Message | Andres Freund | 2026-11-21 17:42:31 | Re: Hash aggregate collisions cause excessive spilling |