Cheat Sheet logoCheat Sheet Today
PostgreSQL Index Types and Strategies/BRIN index for large append-heavy tables

Use BRIN when physical order correlates with query ranges.

Back to sheetBrowse commands
Sign in to save
Section: PostgreSQL index types

BRIN index for large append-heavy tables

sql
sql
CREATE INDEX idx_logs_created_at_brin ON logs USING BRIN (created_at);
Explanation

BRIN can be compact and effective for very large time-series or append-only tables.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing PostgreSQL index types
B-tree index
Default choice for equality, ranges, and ordering.
OpenIn sheetsqlsame section
GIN index on JSONB
Speed containment queries on JSONB data.
OpenIn sheetsqlsame section
Expression index
Index the result of an expression used in predicates.
OpenIn sheetsqlsame section
Partial index
Index only the rows a hot query actually needs.
OpenIn sheetsqlsame section
Create index concurrently
Reduce blocking on busy tables.
OpenIn sheetsqlsame section
Explain with runtime stats
Inspect actual execution behavior.
OpenIn sheetsql1 tag match