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 Rafia Sabih
Parallel Index Scans
This blog will continue the discussion of parallel query in PostgreSQL. In the previous blog of this series, we learned about parallel index scans, its design in PostgreSQL and the performance improvement achieved for a few queries on the industrial benchmark of TPC-H. Therein we analyzed the performance improvement only for a small factor of 20 (...
MORE
By Ken Rugg
Moving to the cloud
With so many workloads being migrated to the cloud, this is a question we get all the time. For anyone making this move there are many choices to make and options to consider. In this post, I will step through those to help you decide on a path forward. First, recognize that not every workload is equally suited for cloud deployment. To properly...
MORE
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 and Germany throughout the Summer. The purpose of...
MORE
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 surprise. According to Yuhanna, the topic of database-...
MORE
By Ashutosh Bapat
Partitioning
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 declarative partitioning, which is much easier to...
MORE
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 amongst those. But it's not possible to calculate...
MORE
By Devrim Gündüz
Amsterdam
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 be at the Tobacco Theatre in Amsterdam, which also...
MORE
By Jeevan Ladhe
Partitioning
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 this by adding a DEFAULT partition. What is...
MORE
By Eric McCormack
Connectors
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 speed on our supported connectors, their Oracle...
MORE
By Daniel Westermann
MiniShift
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 at the end MiniShift got more resources when it was...
MORE