The EDB Blog

EDB Postgres Summer School Tour

By Bruce Momjian
I have been in Europe now for more than two weeks meeting a number of our customers and PostgreSQL users at the EDB Postgres Summer School. So far I have been in Zürich, London and Oslo and there are further events in the Netherlands, France, Czech Republic, Italy, and Belgium, the Nordics, Spain...

Databases in the Cloud: Today's Realities and Tomorrow's Promise

By Ken Rugg
EDB recently had the pleasure of inviting Noel Yuhanna to present at a webinar we hosted— Databases in the Cloud: Today's Realities and Tomorrow's Promise . Yuhanna is a principal analyst at Forrester, serving enterprise architecture professionals. This webinar was well attended, and that was no...

Upgrade your Partitioning from Inheritance to Declarative

By Ashutosh Bapat
Before PostgreSQL 10, Postgres users partitioned their data using inheritance based partitioning. The method used constraints to define the partitions and rules or triggers to route the data to appropriate partition. A user had to write and maintain code for all of that. PostgreSQL 10 introduced...

Planning Queries Involving Foreign PostgreSQL Tables

By Ashutosh Bapat
Cost based optimization A query may be executed in many different ways, modeled as plans in the query optimizer, differing in resources required and/or execution time. A typical DBMS's query optimizer tries to find all of the possible plans for executing a given query and chooses the fastest plan...

PGDay Comes to Amsterdam on July 12th

By Devrim Gündüz
Thought it would be good to make everyone aware that PGDay is coming to Amsterdam for the first time on July 12th and I’m delighted to say I will be there helping to host the day, as well as presenting on Write-Ahead Log (WAL). If you want to find out more you can go to this link . The event will...

Default Partition - Adopting the Odds

By Jeevan Ladhe
PostgreSQL 10 introduced declarative partitioning, which included list and range partitioning. But, it had always been an open question as to what happens if we get rows which do not qualify to be placed in any of the given list/range partitions. That's when PostgreSQL 11 introduces a solution to...

4 Ways to Integrate EDB Postgres Using Popular Interfaces

By Eric McCormack
EnterpriseDB supports a wide array of connectors to integrate your application with EDB Postgres, and our Connectors team has been hard at work, just releasing our Connectors 10.0.2 update. This release made a host of enhancements to all four supported connectors. In this post, I’ll bring you up to...

Deploying EDB Containers in MiniShift/OpenShift

By Daniel Westermann
In this post we’ll look at how we can deploy EnterpriseDB containers in MiniShift . When you need to setup MiniShift have a look here . In this post we’ll do the setup with the MiniShift console, in a next post we’ll do the same by using the command line tools. As a few containers will be running...

Parallel Index Scans in PostgreSQL

By Amit Kapila
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

By Ken Rugg
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

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

By Ken Rugg
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

By ahsan hadi
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

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

GDPR Will Turn DBAs Into Superheroes

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

Row Movement Across PostgreSQL Partitions Made Easy

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