Recent Posts
Advanced Retention Management for Postgres Backups
June 21, 2017
Data retention has become a greater challenge for database administrators as volumes have exploded with new digital applications and data from mobile...
Allowing Only One Null
June 14, 2017
While the sql standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g. ms sql ) allow only a...
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...

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