~/bookmarks

Welcome! Type "help" for available commands.

$

Welcome! Type "help" for available commands.

$

Welcome! Type "help" for available commands.

$

~/bookmarks

William's Bookmark Library

/**/

Unconventional PostgreSQL Optimizations

hakibenita.comSaved January 21, 202619 minJanuary 20, 2026

Haki Benita · via Haki Benita

Summary

The article outlines unconventional PostgreSQL optimizations.

It covers using constraint_exclusion=on to skip full table scans on invalid values via check constraints. It also discusses function-based indexes with virtual generated columns for lower cardinality queries and hash indexes for uniqueness enforcement.

Topics

Hash Indexes PostgreSQL Optimizations Function Based Indexes Constraint Exclusion Query Performance

Visit Site All Bookmarks

William's Bookmark Library

/**/

Unconventional PostgreSQL Optimizations

hakibenita.comSaved January 21, 202619 minJanuary 20, 2026

Haki Benita · via Haki Benita

Summary

The article outlines unconventional PostgreSQL optimizations.

It covers using constraint_exclusion=on to skip full table scans on invalid values via check constraints. It also discusses function-based indexes with virtual generated columns for lower cardinality queries and hash indexes for uniqueness enforcement.

Topics

Hash Indexes PostgreSQL Optimizations Function Based Indexes Constraint Exclusion Query Performance

Visit Site All Bookmarks

~/bookmarks

~/bookmarks

Unconventional PostgreSQL Optimizations

Summary

Topics

Discover Similar Content

How We Made 100M Vector Indexing in 20 Minutes Possible on PostgreSQL

Super fast aggregations in PostgreSQL 19

Avoid UUID Version 4 Primary Keys (for Postgres)

Discover Similar Content

Unconventional PostgreSQL Optimizations

Summary

Topics

Discover Similar Content

How We Made 100M Vector Indexing in 20 Minutes Possible on PostgreSQL

Super fast aggregations in PostgreSQL 19

Avoid UUID Version 4 Primary Keys (for Postgres)