Postgres Index Types
When creating an index using
CREATE INDEX
, Postgres will create a B-Tree type index by default. The B-Tree type is great for general purpose indexes but there are special cases when other types provide better results.
When creating an index using
CREATE INDEX
, Postgres will create a B-Tree type index by default. The B-Tree type is great for general purpose indexes but there are special cases when other types provide better results.