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 Keith Alsheimer
PostgreSQL has long been a popular database, loved by developers and database administrators for its ease of use, comprehensive and intuitive documentation, and reliability. Anyone at EnterpriseDB® (EDB™) could tell you that interest in PostgreSQL (also known as Postgres) has been growing rapidly in recent years, but that might be considered...
MORE
By Robert Haas
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 you create multiple versions of rows, you have to eventually get rid of the row versions somehow. In PostgreSQL, VACUUM is in charge of making sure that happens, and the autovacuum process is in...
MORE
By Ken Rugg
Technology managers are rapidly modernizing their data infrastructures to achieve greater flexibility in today’s hypercompetitive marketplace. They need flexibility over their licensing portfolio, ability to configure modern applications, and choice of deployment environments to keep pace with digital transformation. The State of the Operational...
MORE
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