PostgreSQL Index Types: Beyond the B-tree

Written by packt | Published 2021/02/12
Tech Story Tags: postgresql | database | spgist | hash-indexes-in-postgresql | gist-indexes-in-postgresql | extend-gist-in-postgresql | gin-indexes-postgresql | good-company

TLDR The following guide outlines the purpose of each index type available in PostgreSQL. Each index will serve a special purpose and do exactly what is needed. Additional index types that are available on the web include rum, vodka, and, in the future, cognac. Hash indexes have been around for many years, but before Postgres 10.0 it was not advisable to use hash indexes because Postgres had no W.write-ahead logging support for them. In Postgres' new version, Hash indexes are fully logged and are considered to be 100 crash-safe.via the TL;DR App
no story
Written by packt | We're one of the leading tech book publishers in the UK. We have published 7k+ books, videos, articles, and tutorials.
Published by HackerNoon on 2021/02/12
ABOUTHow hackers start their afternoons. We publish tech stories and build publishing software.

READEntirely free library read by hundreds of millions to learn anything about any technology.

WRITEHackerNoon elevates quality technology writing far and wide across the interwebs.

PARTNERHackerNoon works directly with tech companies to place ads by content relevancy