When to Use Server-Side Logic

The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades.
September 12, 2017

Column Storage Intervals

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 local variables, as outlined...
April 25, 2017

How to Be the Master of Your Database Domain

The increasing deployment of Postgres has brought about new demands for features, capabilities, and tools from developers and database administrators. As the leading Postgres database platform company, EnterpriseDB® (EDB™) works...
November 16, 2016

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

First Rule in Securing Postgres: Don’t Be Dumb

A very popular standalone NoSQL database solution came under criticism about their security posture this week. It’s not the kind of publicity a database company – or any company for...
February 12, 2015

Monitoring Postgres from the Command Line

You might already be aware that Postgres updates the process title of all its running processes. For example, this is a Debian Linux ps display for an idle Postgres server...
August 06, 2012