Why hot_standby_feedback Can Be Misleading

Introduction When I first got involved in managing a Postgres database, I was quickly introduced to the need for replication. My first project was to get our databases up on...
March 19, 2019

Is DocumentDB Really PostgreSQL?

On Thursday I wrote about the new MongoDB compatible DocumentDB from AWS and its potential impact on MongoDB going forward. Following up from that, a colleague pointed me to a...
January 14, 2019

A Real Integration: EFM and PgPool

In this article we are going to see how database servers work together to allow the second server to take over quickly if the primary server fails(high availability), and to...
January 04, 2019

PgBouncer Pro Tip: Use auth_user

Anyone running a database in a production environment with over a hundred users should seriously consider employing a connection pooler to keep resource usage under control.
December 18, 2018

Is MongoDB Still Open Source?

In my role at EDB, I lead the effort to package our software on Debian and I am also the maintainer of the PostgreSQL YUM and ZYPP repositories, so I...
December 14, 2018