The EDB Blog

Recent Posts
ALTERing the Bounds of a Partition
June 12, 2017
PostgreSQL 10 is full with a lot of big, new and exciting features. Declarative partitioning is one of those. It is something users have wanted for...
Postgres Vision Training Day at MIT Ends with Certification
May 26, 2017
In a 2013 McKinsey & Company global survey , 35 percent of executives said improving the talent level and capabilities of IT staff was critical...
Postgres Keywords
May 17, 2017
You might be aware that the sql standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard,...
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...

Top Authors

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

Vice President, Marketing

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

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

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