The EDB Blog

Recent Posts
Index Order Does Matter
April 12, 2017
Postgres has supported multi-column indexes since 1997, e.g. create index i_test on test (a, b, c). It can easily use an index if the supplied...
Customizing Postgres Code: New Feature for Selectively Recording Error Messages
April 11, 2017
EnterpriseDB ® (EDB™) works closely with its customers to develop new features as they encounter needs unique to their environments. Global...
New Features Coming in PostgreSQL 10
April 10, 2017
The list of new features coming in PostgreSQL 10 is extremely impressive. I've been involved in the PostgreSQL project since the 8.4 release cycle (...
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" (...

Top Authors

Technical Architect, EnterpriseDB

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

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

Eric McCormack is a Senior Architect at EnterpriseDB. He has more than 20 years experience in ...

Vice President, Marketing

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