Re: [PATCH] Add planner support function to two-argument regexp_like()

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

In response to

Browse pgsql-hackers by date

  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