The EDB Blog

Follow the EnterpriseDB Blog for the latest on all things EDB Postgres. From news to how-tos, our community of PostgreSQL experts is always sharing leading-edge insights.
By Vibhor Kumar
EDB Postgres Failover Manager (EFM) is a high availability module from EnterpriseDB (EDB) that monitors the health of Postgres clusters and verifies failures quickly. Should one occur, EFM can automatically promote a Standby node to Master to ensure continued performance and protect against data loss. Among EDB customers, virtually all of them...
MORE
By Debra Brucato
PostgreSQL v10 Associate Certification Available  PostgreSQL 10 was the most significant Postgres release in recent years. Available since October 2017, it provided database administrators flexibility, powerful new database features, and an array of new deployment choices. The release expanded deployment options and increased database performance...
MORE
By Thomas Munro
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. As of commit 18042840, assuming nothing irreparably busted is discovered in the next few months, PostgreSQL 11 will ship with Parallel Hash. Partial plans will be possible on both sides of a join for...
MORE
By Robert Haas
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 need for PostgreSQL. In this post, I’d like to examine the history of VACUUM improvements in recent years, the state of VACUUM as it exists in PostgreSQL today, and how it might be improved in the...
MORE
By Marc Linster
To our valued EDB Postgres subscribers: By now, you have likely heard the recent news of the Meltdown and Spectre vulnerabilities. Almost every computing system — desktops, laptops, smartphones, and cloud servers — is affected by Spectre. Meltdown appears to be specific to chips made by Intel. Although such exploits are not directly related to EDB...
MORE
By Dave Page
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 debate about the relative merits of these different approaches. EnterpriseDB® (EDB™) provides a data management platform based on the open source project PostgreSQL and it stands at the junction of open...
MORE
By Ashutosh Bapat
Unlike inheritance-based partitioning, declarative partitioning introduced in PostgreSQL 10 leaves nothing to infer about how the data is divided into partitions. PostgreSQL 11's query optimizer is gearing up to take advantage of this "no-inference" representation. The first one that got committed was basic partition-wise join. What is partition-...
MORE
By Keith Alsheimer
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 readers. Here is a Top 10 recap of your favorites from 2017. 10. Pgpool II Keeps Pace With Demands of Today’s Architectures and Workloads This blog is about Pgpool II, the middleware product that...
MORE
By Robert Haas
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 in fact many people don’t. This blog post is my attempt to explain what MVCC is and why PostgreSQL uses it, what VACUUM is and how it works, and why we need VACUUM to implement MVCC. In addition, I’...
MORE
By Devrim Gündüz
The increasing deployment of Postgres has brought about new demands for features, capabilities, and tools from developers and database administrators. As the leading Postgres database platform company, EnterpriseDB® (EDB™) works closely with customers to respond to their emerging needs. One of the most important contributions EDB makes to the...
MORE