https://boringsql.com/posts/
Learn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.
postsboringsql
https://boringsql.com/archive/
Learn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.
blog postarchiveboringsql
https://boringsql.com/products/regresql/
RegreSQL catches query regressions before production. Compare query outputs against baselines, track EXPLAIN plan costs, and test migrations with confidence.
regression testingsqltool
https://boringsql.com/posts/explain-buffers/
Feb 6, 2026 - Learn how to interpret buffer statistics in PostgreSQL EXPLAIN output. Understand shared hits, disk reads, temp spills, and planning buffers to accurately...
readingbufferstatisticsexplainoutput
https://boringsql.com/visualizers/8kb-page/
Interactive visualization of PostgreSQL's 8KB page: header, line pointers, free space, and tuple data.
insidepostgresqllayoutboringsql
https://boringsql.com/talks/
A collection of past conference talks and presentations about PostgreSQL, SQL, and database engineering.
past talksboringsql
https://boringsql.com/guides/
Learn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.
practicalguidesboringsql
https://boringsql.com/tags/deep-dive/
Learn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.
deep divearticlestaggedboringsql
https://boringsql.com/about/
BoringSQL provides practical resources and insights on SQL and PostgreSQL, tailored to help developers at all levels master essential techniques and best...
boringsql
https://boringsql.com/posts/inside-the-8kb-page/
Feb 19, 2026 - A byte-level tour of the 8KB page. PostgreSQL's atomic unit of storage. We deep dive into page headers, line pointers, and free space using pageinspect to see...
insidepostgresqlboringsql
https://boringsql.com/
Learn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.
boringsqlsuperchargepostgresqlpowers
https://boringsql.com/visualizers/shared-buffers/
Interactive visualization of PostgreSQL's buffer pool, clock sweep eviction, and hash table lookups.
postgresqlsharedbuffersboringsql
https://boringsql.com/posts/introduction-to-buffers/
Jan 24, 2026 - How PostgreSQL actually manages memory, from shared_buffers and dirty pages to the OS page cache sitting underneath it all.
introductionbufferspostgresqlboringsql
https://boringsql.com/posts/good-bad-arrays/
Deep dive into PostgreSQL arrays: why they're document storage in disguise, the TOAST performance trap, GIN vs B-tree indexing, the dangerous ANY()...
hiddencostpostgresqlarraysboringsql
https://boringsql.com/products/fixturize/
Subset and mask PostgreSQL production data in one step. Extract referentially intact slices with PII masking, so you get production-realistic test data without...
data maskingpostgresqltoolboringsql
https://boringsql.com/tags/internals/
Learn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.
articlestaggedinternalsboringsql