Allow to use an index for ILIKE in more cases

Title

CI (CFBot)

Needs rebase! Needs rebase since 8 months. Failing since 7 months.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2025-01-14 16:42:36

Last modified

2025-04-03 03:35:47 (6 months ago)

Latest email

2025-03-31 14:09:56 (7 months ago)

Status

2025-03 (2025-03-01 – 2025-04-08): Withdrawn

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-03-31 14:09:56 by Yugo NAGATA <nagata at sraoss.co.jp>
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-04-03 03:35:47	Yugo Nagata (yugo.nagata)	Closed in commitfest 2025-03 with status: Withdrawn
2025-03-11 04:14:17	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
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