The EDB Blog

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

PostgreSQL

DO or UNDO - There is no PostgreSQL VACUUM

Robert Haas January 30, 2018

What if PostgreSQL didn’t need VACUUM at all? This seems hard to imagine. After all, PostgreSQL uses multi-version concurrency control (MVCC), and if...

Ready to Test Your Postgres Skills?

Debra Brucato January 18, 2018

PostgreSQL v10 Associate Certification Available PostgreSQL 10 was the most significant Postgres release in recent years. Available since October 2017...

Parallel Hash for PostgreSQL

Thomas Munro January 16, 2018

PostgreSQL 9.6 and 10 can use all three join strategies in parallel query plans, but they can only use a partial plan on the outer side of the join...

The State of VACUUM

Robert Haas January 9, 2018

In a recent blog post, I talked about why every system that implements MVCC needs some scheme for removing old row versions, and how VACUUM meets that...

Deciding on Your Open Source Strategy

Dave Page January 4, 2018

When it comes to enterprises deciding on whether to adopt open source software or commercial software based on open source it can lead to fierce...

Partition-wise Joins: “Divide and Conquer" for Joins Between Partitioned Table

Ashutosh Bapat January 2, 2018

Unlike inheritance-based partitioning, declarative partitioning introduced in PostgreSQL 10 leaves nothing to infer about how the data is divided into...

Top 10 Countdown - EDB Blog Reader Favorites for 2017

Keith Alsheimer December 27, 2017

As we approach year end, our EDB team was inspired to take a look back at our blog posts from the year and see what topics resonated the most with our...

MVCC and VACUUM

Robert Haas December 19, 2017

Experienced PostgreSQL users and developers rattle off the terms “MVCC” and “VACUUM” as if everyone should know what they are and how they work, but...

Master Your Database Domain

Devrim Gündüz December 15, 2017

The increasing deployment of Postgres has brought about new demands for features, capabilities, and tools from developers and database administrators...

Be Sure to Stop Your Backups!

Richard Yen December 12, 2017

This article is about using pg_stop_backup() when setting up Streaming Replication. It is not an article about backup/restore methodology or policy...