The EDB Blog

  1. Home
  2. The EDB Blog

DO or UNDO - There is no VACUUM

1/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 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...

More

Best of Both Worlds: Integrating Pgpool with EDB Postgres Failover Manager

1/23/2018
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...

More

Ready to Test Your Postgres Skills?

1/18/2018
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...

More

Parallel Hash for PostgreSQL

1/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. As of commit 18042840 , assuming nothing irreparably busted is discovered in the next few months, PostgreSQL 11 will ship with Parallel Hash. Partial...

More

The State of VACUUM

1/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 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...

More

Meltdown and Spectre Vulnerabilities Explained

1/5/2018
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...

More

Deciding on Your Open Source Strategy

1/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 debate about the relative merits of these different approaches. EnterpriseDB ® (EDB™) provides a data management platform based on the open source project...

More

Top 10 Countdown - EDB Blog Reader Favorites for 2017

12/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 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...

More

MVCC and VACUUM

12/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 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...

More

Master Your Database Domain

12/15/2017
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...

More

Be Sure to Stop Your Backups!

12/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. Introduction In a recent support case, I came across a customer who used a clever way to create streaming replication base backups–by taking a Google...

More

Postgres vs. PostgreSQL

12/7/2017
I have been with the project long enough to remember how the project got the name "PostgreSQL". In 1996, we inherited the name "Postgres95" from the Berkeley team's remaining member Jolly Chen. Obviously the Postgres95 name wasn't going to last long-term, so a new name had to be chosen. We could...

More

4 Tips for Postgres Administration

12/5/2017
Postgres Alerts It is cool to be able to stare at colorful graphs to see what Postgres is doing, but sometimes you just want to setup something, walk away, and be informed when there is problem. That is what check_postgres and tail_n_mail are designed to do. check_postgres is a script designed to...

More