We've released an off-schedule update release today , because of a bug in one of 9.5's features which has forced us to partially dis...

If you downloaded 9.5 after yesterday's release , you might have noticed some changes to postgresql.conf, especially if you copied over ...

In 2008, when Heroku started, there was only one real option for cloud hosting PostgreSQL: roll-your-own on EC2, or a couple other not-very-...

Here's a commonplace ops crisis: the developers push a new dashboard display widget for user homepages on your application.  This seems ...

Based on some comments in my post about "in-memory" databases , I realized that my post about running Postgres without disk sy...

So, I'm hearing again about the latest generation of "in-memory databases". Apparently Gartner even has a category for them no...

Continued from Part 2 . The next test is two tags combined.  This is where the alternative approaches really pull ahead of the tradition...

Many web applications are designed with a "tags" feature, where users can add arbitrary string "tags" to  each document ...

A month ago I got into an argument on IRC with Sergey about telling people to avoid kernel 3.2 .  This turned out to be a very productive ar...

I've been doing some comparative testing on different cloud platform's hosting of PostgreSQL.  And one of the deficiencies in this e...

Unlike some other SQL databases, PostgreSQL does not automatically create indexes on the "child" (in formal language "refere...

To accompany the New Index Bloat Query , I've written a New Table Bloat Query .  This also involves the launch of the pgx_scripts proje...

In fact, you really need to avoid every kernel between 3.0 and 3.8.  While RHEL has been sticking to the 2.6 kernels (which have their own i...