An index is a database object that improves the speed of data retrieval operations on a table. PostgreSQL provides several specialized index types, each optimized for different data structures and query patterns. ![[ex_index_only_scan.svg|300x300]] ### ![[BTree]] ### ![[Hash]] ### ![[GiST]] ### ![[SPGiST]] ### ![[GIN]] ### ![[BRIN]] ### ![[HNSW]] ### ![[IVFFLAT]]