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...
Summer can provide the quiet time many database administrators and architects need to focus time and attention on acquiring new skills or sharpening existing abilities....
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...
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 supports both traditional join syntax, which uses the where clause...
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...
Summer can provide the quiet time many database administrators and architects need to focus time and attention on acquiring new skills or sharpening existing abilities....
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...
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...