Login Register

Internals//GIN Indexes: Examples

The PostgreSQL source distribution includes GIN operator classes for tsvector and for one-dimensional arrays of all internal types. Prefix searching in tsvector is implemented using the GIN partial match feature. The following contrib modules also contain GIN operator classes:

btree_gin: B-tree equivalent functionality for several data types
hstore: Module for storing (key, value) pairs
intarray: Enhanced support for int[]
pg_trgm: Text similarity using trigram matching

Prev		Next
Limitations	Up	BRIN Indexes

Links:

https://www.postgresql.org/docs/9.6/static/gin-examples.html

doc_PostgreSQL

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

Internals//GIN Indexes: Limitations GIN assumes that indexable operators are strict. This means that extractValue will not be called at all on a null item value (instead, a placeholder

Internals//GIN Indexes GIN stands for Generalized Inverted Index. GIN is designed for handling cases where the items to be indexed are composite values, and the queries to

Internals//GIN Indexes: Extensibility The GIN interface has a high level of abstraction, requiring the access method implementer only to implement the semantics of the data type being acc

Internals//GIN Indexes: Implementation Internally, a GIN index contains a B-tree index constructed over keys, where each key is an element of one or more indexed items (a member of an arra

Internals//GIN Indexes: GIN Tips and Tricks Create vs. insert Insertion into a GIN index can be slow due to the likelihood of many keys being inserted for each item. So, for bulk insertions i