Every Postgres index type, and the bug you get when you pick wrong
B-tree is the default, but it is the wrong choice more often than you expect. This guide covers all six Postgres index types, the bug each was built to prevent, and the gotcha that disables each one silently.