The EDB Blog

Data in the Database vs. the File System

2/20/2018
An age-old question is whether it is better to put data in a database or a file system. Of course, the answer is "it depends," but let's look at what it depends on. First, Postgres stores its data in the file system, so the file system must be good for something. Postgres also stores some of its...

Untangling Years of Layered Legacy Systems

2/16/2018
Financial Services Institutions Look to Open Source Today’s financial services institutions must innovate and evolve their technology to remain competitive during a time of great disruption. The need for rapid innovation and increasing digitalization is shining a light on the IT complexity many...

BART 2.2 Sneak Peak

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?

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?

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’

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

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

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?

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

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

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

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

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

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