The EDB Blog

Recent Posts
Expression Index Statistics and Joins
April 05, 2017
In my previous blog post, I showed how statistics generated on expression indexes can be used to produce more accurate row counts, and potentially...
Pgpool-II Keeps Pace With Demands of Today’s Architectures and Workloads
March 30, 2017
Middleware can have a significant impact on the operation and performance of the database system. Pgpool-II is the middleware product that sits...
Still No Query Hints?
March 28, 2017
So, it is 2017 and Postgres still doesn't support query hints like other relational databases? Yep, it's true, and probably will be forever since "'...
PostgreSQL Indexes: Hash Indexes are Faster than Btree Indexes?
March 24, 2017
*/ PostgreSQL have supported Hash Index for a long time, but they are not much used in production mainly because they are not durable. Now, with the...
Statistics on Expression Indexes
March 22, 2017
Most people know that Postgres allows the creation of indexes on expressions. This is helpful if you need index lookups of expressions used in where...
EDB Postgres Ark: Leveraging AWS Services for Integrated EDB Postgres Deployments
March 20, 2017
The EDB Postgres™ Ark from EnterpriseDB ® (EDB™) is a Database-as-a-Service (DBaaS) framework for hybrid cloud deployments of Postgres to private and...
Parallel Query v2
March 16, 2017
A recent Twitter poll asked What is your favorite upcoming feature of PostgreSQL V10? In this admittedly unscientific survey, "better parallelism" (...
Getting the Most of out Application_Name
March 15, 2017
Application_name might be one of those Postgres settings that you have seen in various places but never understood its purpose. It is true that...
Combining Partitioning and FDWs for Real Time Analytics
March 14, 2017
Since v9.1 PostgreSQL has been steadily improving its Foreign Data Wrapper (FDW) capabilities. FDWs are a way to access and manipulate data external...
Wait Event Reporting
March 13, 2017
Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn...

Top Authors

Technical Architect, EnterpriseDB

Jan is Director of Sales Engineering at EnterpriseDB. In this role Jan supports the DACH-regio...

John Dalton is Senior Director of Product Management, responsible for product strategy and man...

Dave has been actively involved in the PostgreSQL Project since 1998, as the lead developer of...

Vice President, Marketing

Frank Days is EDB's Vice President of Marketing. He has he...