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 Amit Kapila
Parallel Index Scans
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 this feature is and the amount of work being done on...
MORE
By Ken Rugg
Postgres Vision 2018
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 two. The second day of Postgres Vision 2018 was...
MORE
By Marc Linster
Data Maturity Curve
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 discussed the opportunity of running Postgres...
MORE
By Ken Rugg
Containers
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 time, few knew what they actually were. Yet, for...
MORE
By ahsan hadi
Apple Crop
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 well as the support period for every release. BART 1...
MORE
By Robert Haas
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 added are independently useful, but I believe that...
MORE
By Marc Linster
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 compliance in time (Forrester suggests just under...
MORE
By Amit Khandekar
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. With declarative partitioning, when you insert a...
MORE
By Ken Rugg
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. Forrester Research reported that 48% of mid-size...
MORE
By Thomas Munro
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 efficient with those indexes, filling in some of the...
MORE