On 8th of February, Peter Eisentraut committed patch:
Per-column collation support
This adds collation support for columns and domains, a COLLATE clause
to override it per expression, and B-tree index support.
reviewed by Pavel Stehule, Itagaki Takahiro, Robert Haas, Noah Misch
Continue reading Waiting for 9.1 – Per-column collation support
On 1st of February, Tom Lane committed patch:
Support LIKE and ILIKE index searches via contrib/pg_trgm indexes.
Unlike Btree-based LIKE optimization, this works for non-left-anchored
search patterns. The effectiveness of the search depends on how many
trigrams can be extracted from the pattern. (The worst case, with no
trigrams, degrades to a full-table scan, so this isn't a panacea. But
it can be very useful.)
Alexander Korotkov, reviewed by Jan Urbanski
Continue reading Waiting for 9.1 – Faster LIKE/ILIKE