Go back to using a separate method for doing ILIKE for single byte
Andrew Dunstan <andrew@dunslane.net>
Go back to using a separate method for doing ILIKE for single byte character encodings that doesn't involve calling lower(). This should cure the performance regression in this case complained of by Guillaume Smet. It still leaves the horrid performance for multi-byte encodings introduced in 8.2, but there's no obvious solution for that in sight.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/like.c | modified | +35 −10 |
| src/backend/utils/adt/like_match.c | modified | +20 −7 |