2026-05-20PostgreSQL 18: BTree vs Hash Indexes — A BenchmarkBTree or Hash index? char(1) or varchar(1000)? I benchmarked PostgreSQL 18.4 with 100K rows across index types, column widths, and cardinalities.PostgreSQLBenchmarkDatabasePerformance