The EDB Blog

BART 2.2 Sneak Peek

By ahsan hadi
2/13/2018
The EDB Postgres Backup and Recovery Tool development team is super busy developing features for the next major release and I wanted to give everyone a sneak peek into the exciting new capabilities to be delivered as part of BART 2.2. The last major release of BART was published in June 2017 and we...

What is 256 Pages Long with 99 Articles, and Has Teeth?

By Marc Linster
2/12/2018
Explore How GDPR Impacts a DBA On May 25, 2018, the General Data Protection Regulation (GDPR) will take effect, and it will impact the way your organization collects and manages customer data in Europe. GDPR effectively replaces the data protection directive 9546EC, and is not just applicable to...

What Happens if You Don’t Monitor Your PostgreSQL Database Effectively?

By ajay patel
2/6/2018
A good DBA is someone who knows how to monitor the databases EFFECTIVELY and when it comes to a production or business critical database, the job becomes even more crucial. ​Not monitoring your databases and system effectively may lead to a severe catastrophe - application slowness, database...

Plenty to Celebrate with Postgres the ‘DBMS of the Year’

By Keith Alsheimer
2/1/2018
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...

DO or UNDO - There is no VACUUM

By Robert Haas
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...

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

By Vibhor Kumar
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...

Ready to Test Your Postgres Skills?

By Debra Brucato
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...

Parallel Hash for PostgreSQL

By Thomas Munro
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...

The State of VACUUM

By Robert Haas
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...

Meltdown and Spectre Vulnerabilities Explained

By Marc Linster
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...

Deciding on Your Open Source Strategy

By Dave Page
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...

Top 10 Countdown - EDB Blog Reader Favorites for 2017

By Keith Alsheimer
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...

MVCC and VACUUM

By Robert Haas
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...

Master Your Database Domain

By Devrim Gündüz
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...