v.25.6Experimental Feature

Experimental indexes of type gin

Official CH changelog text
Experimental indexes of type gin (which I don't like because it is an inside joke of PostgreSQL hackers) were renamed to text. Existing indexes of type gin remain loadable but they will throw an exception (suggesting text indexes instead) when one tries to use them in searches. #80855 (Robert Schulze).
Renamed experimental indexes of type gin to text to improve clarity and usage consistency.

Why it matters

The rename addresses confusion caused by the gin index type name, which was an inside joke related to PostgreSQL and not intuitive for users. This change helps users adopt the new text index type for text search functionality and prevents accidental usage of deprecated gin indexes.

How to use it

Users should create and use text indexes instead of the deprecated gin type. Existing gin indexes remain loadable but will raise exceptions if used in searches, recommending migration to text indexes.

Related resources

PreviousNext