PostgreSQL Index Types: Beyond the B-treeby@packt
857 reads

PostgreSQL Index Types: Beyond the B-tree

February 12th 2021
12 min
by @packt 857 reads
tldt arrow
Read on Terminal ReaderPrint this storyRead this story w/o Javascript

Too Long; Didn't Read

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.

Companies Mentioned

Mention Thumbnail
Mention Thumbnail

Coin Mentioned

Mention Thumbnail
featured image - PostgreSQL Index Types: Beyond the B-tree
Packt HackerNoon profile picture

@packt

Packt

react to story with heart
Packt HackerNoon profile picture
by Packt @packt.We're one of the leading tech book publishers in the UK. We have published 7k+ books, videos, articles, and tutorials.
Read my stories

RELATED STORIES

L O A D I N G
. . . comments & more!
Hackernoon hq - po box 2206, edwards, colorado 81632, usa