The EDB Blog

Parallel Index Scans in PostgreSQL

6/12/2018
There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequential Scans ). Each of the past three releases (including PG-11 , which is in its beta) have a parallel query as a major feature which in itself says how useful...

Postgres Vision 2018 Day Two Recap

6/8/18
That’s a wrap! Another Postgres Vision is now in the books and it was a resounding success. The EDB team took to Cambridge to host our 3rd annual enterprise Postgres event at the Royal Sonesta hotel. If you missed it, you missed a lot! Check out our day one recap , and read on for a summary of day...

Opening Day for Postgres Vision 2018

6/6/2018
Yesterday, we kicked off Postgres Vision 2018, the enterprise Postgres event, in Cambridge, MA. This 3rd annual event is at the Royal Sonesta hotel and brings together the Postgres business, technical, and open source community. In the opening keynote delivered by Ed Boyajian of EnterpriseDB, he...

Containers: A Hype Machine Becomes the Real Deal

5/31/2018
A few short years ago, I recall attending a conference where the goal was to title your presentation with the word “Docker” in as many times as possible. This was a guaranteed way to generate buzz, because containers were a hype machine. And, although everyone was very hyped about containers at the...

Find the Right Version of BART and Pgpool II

5/29/2018
We encounter some confusion around which versions of EDB Postgres Backup and Recovery Tool (BART) are supported with which version of our database server, EDB Postgres Advanced Server (EPAS). This calls for publishing a BART support matrix to describe the BART/Database server version support as...

Built-in Sharding for PostgreSQL

5/22/2018
Built-in sharding is something that many people have wanted to see in PostgreSQL for a long time. It would be a gross exaggeration to say that PostgreSQL 11 (due to be released this fall) is capable of real sharding, but it seems pretty clear that the momentum is building. The capabilities already...

GDPR Will Turn DBAs Into Superheroes

5/18/2018
The world is awash with statistics about the General Data Protection Regulation (GDPR) and depending on who you believe, companies are either completely ready ( this study says 72% of global businesses are confident of compliance) or there is still a large portion of companies who will not achieve...

Row Movement Across PostgreSQL Partitions Made Easy

5/15/2018
Before declarative partitioning was introduced in PostgreSQL 10, one had to use table inheritance. One of the main drawbacks of using table inheritance is that ROW triggers are needed for the parent table to automatically route the inserted row to the right child table, which is cumbersome and slow...

GDPR Could Become a Costly Millstone that Slows Down Business Agility

5/10/2018
The General Data Protection Regulation (GDPR) has been one of the large ticket items for IT departments in the last year. According to PWC , 68% of large US multinationals will have spent between $1 million and $10 million on GDPR readiness and compliance in the lead up to the May 25, 2018 deadline...

SERIALIZABLE in PostgreSQL 11... and beyond

5/8/2018
Thanks to the tireless work of Google Summer of Code student Shubham Barai with the support of reviewers, a mentor, and a committer, PostgreSQL 11 will ship with predicate lock support for hash indexes , gin indexes and gist indexes . These will make SERIALIZABLE transaction isolation much more...

Do You Have the Essential Skills to Be a Successful PostgreSQL DBA?

5/4/2018
Open source databases are becoming an increasingly preferred option for organizations seeking high performance, lower cost alternatives to legacy databases. According to a report by Gartner Research, more than 70% of new in-house applications will be developed on an open-source DBMS. 1 As...

Running EDB Postgres Failover Manager Without Sudo

4/24/2018
In the default mode of operation, EDB Postgres Failover Manager (EFM) agents run as the ‘efm’ operating system user. The agent uses sudo to perform various operating system and database tasks. More information about how sudo is used is in the Extending Failover Manager Permissions section of the...

EnterpriseDB Updates Tools, and Enhances Security and Alerting

4/19/2018
Database administrators need tools for database maintenance, performance optimization, and configuration as well as creating a highly available supportive infrastructure. EnterpriseDB (EDB) leads the industry in creating best-in-class Postgres tools to support DBAs with their mission critical...

Intermediate Certificates

4/10/2018
I previously mentioned the importance of high quality documentation, so we are always looking for improvements. This email thread from 2013 attempted to codify the rules for how to properly use intermediate ssl/tls certificates with Postgres. At this time, our documentation was updated to recommend...

Encryption Module in EDB Postgres Earns FIPS 140-2 Validation

4/6/2018
U.S. government agencies and other organizations that require higher levels of security now have another green light on the road to open source. The Cryptographic Module Validation Program (CMVP), operated by the National Institute of Standards and Technology (NIST), has awarded a coveted FIPS 140-...

Wal and Xlog

4/3/2018
Postgres isn't the best at naming things. Of course, there is the old computer saying, "There are only two hard things in Computer Science: cache invalidation and naming things." With Postgres being 31 years old and developed by several different project teams, naming can be even more inconsistent...