A Little Respect for Pgpool-II

Middleware doesn’t get the respect it deserves. Considered the glue that holds together the more complex and more business-critical components in the software stack, middleware is often installed and forgotten...
April 07, 2016

Building JSON Documents from Relational Tables

Adoption of document databases is growing rapidly in response to the need for solutions that can handle large volumes of data. These solutions are adept at handling non-relational data models...
March 15, 2016

What’s Under the Radar in PostgreSQL 9.5?

The release of PostgreSQL 9.5 marks a turning point for enterprises using PostgreSQL for the development of high-speed mobile, web and digital economy applications, many for customer engagement.
January 08, 2016

Parallelism Becomes a Reality in Postgres

Parallelism is now a reality in PostgreSQL. With 9.6, I hope we will see many different forms of queries that can use parallelism to execute. For now, I will limit...
December 14, 2015

Parallel Sequential Scan is Committed!

I previously suggested that we might be able to get parallel sequential scan committed to PostgreSQL 9.5. That did not happen. However, I'm pleased to report that I've just committed...
November 11, 2015

Postgres + JSON = NoSQL Functionality

It doesn’t take a specialized solution to create an unstructured database to support workloads for emerging mobile, social and machine data. Certainly, NoSQL-only solutions have a place in the data...
September 10, 2015

Postgres at the Center of Everyone’s Data World

The typical data center today contains a patchwork of data management technologies. From enterprise-class relational databases to limited, standalone NoSQL-only solutions to specialized extensions, the arsenal for managing data has...
April 16, 2015

PostgreSQL Shutdown

PostgreSQL has three shutdown modes: smart, fast, and immediate. For many years, the default has been "smart", but Bruce Momjian has just committed a patch to change the default to...
April 01, 2015