The EDB Blog

The latest thought leadership pieces from EDB, including company and PostgreSQL announcements

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

Thom Brown 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

Thom Brown 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

Thom Brown 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

Thom Brown 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

Thom Brown 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

Thom Brown Nov 20, 2014

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