Allow to use an index for ILIKE in more cases

Title

Topic

Performance

Created

2025-01-14 16:42:36

Last modified

2025-01-14 16:42:51 (3 days, 14 hours ago)

Latest email

2025-01-16 17:41:35 (1 day, 13 hours ago)

Status

2025-03: Needs review

Target version

Authors

Yugo Nagata (yugo.nagata)

Reviewers

Committer

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5505
git checkout commitfest/cf/5505

Emails

Allow ILIKE forward matching to use btree index: First at 2024-12-19 18:22:26 by Yugo Nagata <nagata at sraoss.co.jp>
Latest at 2025-01-16 17:41:35 by Jeff Davis <pgsql at j-davis.com>
Latest attachment (v2-0003-Allow-ILIKE-forward-matching-to-use-spgist-index.patch) at 2025-01-14 16:40:46 from Yugo NAGATA <nagata at sraoss.co.jp>
Attachment (v2-0003-Allow-ILIKE-forward-matching-to-use-spgist-index.patch) at 2025-01-14 16:40:46 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
Attachment (0002-Allow-ILIKE-forward-matching-to-use-btree-index.patch) at 2024-12-19 18:22:26 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)

History

When	Who	What
2025-01-14 16:42:51	Yugo Nagata (yugo.nagata)	Changed authors to Yugo Nagata (yugo.nagata)
2025-01-14 16:42:51	Yugo Nagata (yugo.nagata)	Changed targetversion to 18
2025-01-14 16:42:36	Yugo Nagata (yugo.nagata)	Attached mail thread 20241220032226.9a3429207417d28b7e482024@sraoss.co.jp
2025-01-14 16:42:36	Yugo Nagata (yugo.nagata)	Created patch record