Allow to use an index for ILIKE in more cases

Title

CI (CFBot)

Needs rebase! Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Topic

Performance

Created

2025-01-14 16:42:36

Last modified

2025-01-14 16:42:51 (1 month ago)

Latest email

2025-01-16 17:41:35 (1 month ago)

Status

2025-03: Needs review

Target version

Authors

Yugo Nagata (yugo.nagata)

Reviewers

Committer

Links

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-02-17 12:38:31	CFbot	Patch needs rebase
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