Blog Posts by Thom Brown
PostgreSQL Write-Ahead Logging (WAL) Tradeoffs: Bounded vs. Archived vs. Replication Slots
PostgreSQL Write-Ahead Logging (WAL) Trade-offs: Bounded vs. Archived vs. Replication Slots
May 28, 2020

This week, a customer I was working with wanted help setting wal_keep_segments—the number of extra transaction log files to keep on the primary...

jsquery vs SQL/JSON
Aug 30, 2019

SQL/JSON is coming to PostgreSQL 12 and provides a native way to query JSON data (although, to be specific, JSON data stored as a JSONB data type)...

Monitoring in PostgreSQL 9.6
Apr 26, 2016

This is part 2 in a 4 part blog series on improvements coming in PostgreSQL 9.6. Part 1 - Horizontal Scalability Join Pushdown Sort Pushdown "Walk and...

Horizontal Scalability in PostgreSQL 9.6 - Revisited
Apr 7, 2016

In my previous blog post about horizontal scalability changes in PostrgreSQL 9.6, I covered pushing sorts and joins to the remote server, but Robert...

Horizontal Scalability in PostgreSQL 9.6
Apr 7, 2016

.inline-cta { margin: 11px 0; } .inline-cta.cta-tall { margin: 30px 0; } .inline-cta b { font-size: 18px; } PostgreSQL 9.6 is shaping up to be an...

The Big Book of PostgreSQL
Nov 20, 2014

Documentation is crucial to the success of any software program, particularly open source software (OSS), where new features and functionality are...