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...
Since v9.1 PostgreSQL has been steadily improving its Foreign Data Wrapper (FDW) capabilities. FDWs are a way to access and manipulate data external to PostgreSQL...
Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn't require as much...
A fundamental question database administrators ask before deploying replication services is what they can expect in terms of performance. As described below, if a...
Postgres plays a central role in today’s integrated data center. A powerful feature called a Foreign Data Wrapper (FDW) in Postgres supports data integration by...
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...
A recent Twitter poll asked 
Application_name
Since v9.1 PostgreSQL has been steadily improving its Foreign Data Wrapper (FDW) capabilities. FDWs are a way to access and manipulate data external to PostgreSQL...
Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn't require as much...
A fundamental question database administrators ask before deploying replication services is what they can expect in terms of performance. As described below, if a...
The new EDB Postgres™ Platform 2017 from EnterpriseDB® (EDB™) gives enterprises the capability,...
Postgres plays a central role in today’s integrated data center. A powerful feature called a Foreign Data Wrapper (FDW) in Postgres supports data integration by...