The EDB Blog

Recent Posts
Cheat Sheet: Configuring Streaming Postgres Synchronous Replication
May 10, 2017
*/ (This blog was co-written by Sunil Narain.) Streaming replication in PostgreSQL can be asynchronous or synchronous. The Postgres synchronous...
Transitioning Synchronous Standby to Asynchronous in EDB Postgres
May 04, 2017
In the world of solution architecture, where we as solution architects are developing configurations to meet specific customer needs, we often...
Who Contributes to PostgreSQL Development?
April 27, 2017
In a talk which I gave at PGCONF.IN and, in a shorter version, at PGCONF.US, I had a few slides on who contributes to PostgreSQL development. Here, I...
Column Storage Intervals
April 25, 2017
Postgres uses native cpu alignment to store values in a row. This allows blocks to be copied unchanged from disk into shared buffers and accessed as...
Creating Descending Indexes
April 18, 2017
You might have noticed that create index allows you to specify asc or desc for each column being indexed, and you might have wondered why. Asc is the...
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...

Get Postgres Tips and Tricks

Subscribe to our newsletter to get advanced Postgres how-tos.

 

Top Authors

Phil has 25 years experience working with relational database systems and is a Senior Consulta...

Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video ...

Vice President, Marketing

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

Bhavani Rao is a Senior Product Marketing Manager for EnterpriseDB, responsible for product me...

Raghavendra Rao is a Managing Consultant in Professional S...