Generalized Inverted Index - GIN Index - Full Text Search İçindir

Giriş

GIN bir Full Text Search için kullanılır. Açıklaması şöyle

The GIN (Generalized Inverted Index) index is a specialized index type in PostgreSQL designed for efficient full-text search. When a GIN index is created on a `ts_vector` column, it builds an index structure that maps each lexeme to the documents that contain it. This index is optimized for quick lookups, making it ideal for full-text search operations.

Açıklaması şöyle

The GIN index enables PostgreSQL to perform queries involving the `@@` operator, which checks if a `ts_vector` column matches a `tsquery` (a query expressed in the same tokenized format). The GIN index speeds up the search by efficiently locating the relevant documents based on the lexemes present in the search query, without the need for a sequential scan of all documents.

TSVECTOR Sütun Tipine Göre Index

TSVECTOR Sütun Tipine Göre Index yazısına taşıdım

TEXT  Sütun Tipine Göre Index

Örnek

Şöyle yaparız

CREATE INDEX trgm_idx on storm_events USING gin(event_type gin_trgm_ops);

JSONB Sütun Tipine Göre Index

JSONB Sütun Tipine Göre Index yazısına taşıdım