The reaction to the new table partitioning feature in PostgreSQL 10 has been overwhelmingly positive, but a number of people have already astutely observed that there is...
Data now comes in a wide variety of formats, giving rise to more heterogeneous data collections resulting from a commonly employed strategy of choosing the data...
In my role, I frequently talk to organizations about their top priorities for their software applications. Time and again, speed to market wins the day. They consistently...
Think about the old days. Infrastructure software was deployed and managed on a “per server” basis. Later that moved to the socket, and then to the core, and then to the...
The sharpest minds in data management gathered for Postgres Vision 2017 this week in Boston to begin shaping a future with open source for harvesting strategic value...
Data retention has become a greater challenge for database administrators as volumes have exploded with new digital applications and data from mobile, web, and machine...
You might be aware that the sql standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard, with slight...
(This blog was co-written by Sunil Narain.) Streaming replication in PostgreSQL can be asynchronous or synchronous. The synchronous option provides greater data...
In the world of solution architecture, where we as solution architects are developing configurations to meet specific customer needs, we often consider a great...
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'd like to present...
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 columns are all at the...
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 (2008-2009...
Middleware can have a significant impact on the operation and performance of the database system. Pgpool II is the middleware product that sits between the PostgreSQL...
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 "'Oracle-style'...
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 next version of...
The EDB Postgres™ Ark from EnterpriseDB® (EDB™) is a Database-as-a-Service (DBaaS) framework for hybrid cloud deployments of Postgres to private and public...
The reaction to the new table partitioning feature in PostgreSQL 10 has been overwhelmingly positive, but a number of people have already astutely observed that there is...
In a March 
Data now comes in a wide variety of formats, giving rise to more heterogeneous data collections resulting from a commonly employed strategy of choosing the data...
In my role, I frequently talk to organizations about their top priorities for their software applications. Time and again, speed to market wins the day. They consistently...
Postgres supports both 
Think about the old days. Infrastructure software was deployed and managed on a “per server” basis. Later that moved to the socket, and then to the core, and then to the...
The sharpest minds in data management gathered for Postgres Vision 2017 this week in Boston to begin shaping a future with open source for harvesting strategic value...
Data retention has become a greater challenge for database administrators as volumes have exploded with new digital applications and data from mobile, web, and machine...
While the sql standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g....
PostgreSQL 10 is full with a lot of big, new and exciting features....
In a 2013 McKinsey & Company 
You might be aware that the sql standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard, with slight...
(This blog was co-written by Sunil Narain.) Streaming replication in PostgreSQL can be asynchronous or synchronous. The synchronous option provides greater data...
In the world of solution architecture, where we as solution architects are developing configurations to meet specific customer needs, we often consider a great...
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'd like to present...
Postgres uses native cpu alignment to store values in a row. This allows blocks to be copied unchanged from disk into...
You might have noticed that 
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 columns are all at the...
EnterpriseDB® (EDB™) works closely with its customers to develop new features as they encounter needs unique to their environments. Global...
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 (2008-2009...
In my previous 
Middleware can have a significant impact on the operation and performance of the database system. Pgpool II is the middleware product that sits between the PostgreSQL...
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 "'Oracle-style'...
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 next version of...
Most people know that Postgres allows the creation of 
The EDB Postgres™ Ark from EnterpriseDB® (EDB™) is a Database-as-a-Service (DBaaS) framework for hybrid cloud deployments of Postgres to private and public...