Managing large tables is a big challenge. But maintaining good performance and manageability for those large tables is even a bigger challenge. Luckily, Postgres 11 provides several ways of dealing...
Benchmarking is hard. Benchmarking databases is even harder. Benchmarking databases that follow different approaches (relational vs document) is harder still. But the market demands these kinds of comparisons. Despite the...
Postgres Sees a Sharp Rise in Popularity with Developers For a long time now, PostgreSQL has been one of the most frequently deployed relational database management systems. Over the past...
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...
The world of the Database Administrator (DBA) has changed since the technology went mainstream in the 1970s, writes Bruce Momjian, co-founder of the PostgreSQL Global Development Group. Over the last...
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...
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...
TOAST stands for The Oversized-Attribute Storage Technique. EDB Postgres and PostgreSQL use a fixed page size (commonly 8 KB), and does not allow tuples to span multiple pages. Therefore, it...
There is a lot of excitement around today’s release of PostgreSQL 11 – the big annual software update that represents the combined efforts of everyone in the community.
