One of PostgreSQL's advantages over many other SQL databases is letting users modify database objects with a minimum of locking and fuss...

I write a lot more PL/pgSQL than I'd like to.  Not that I don't like SQL, but as a language PL/pgSQL really shows its thrown-togethe...

If you've been following the tech news, you might have noticed that we have a new open source PostgreSQL fork called " PipelineDB ...

By now you've read about PostgreSQL 9.5 and our shiny new UPSERT feature .  And you're thinking, "hey, 9.5 is still in alpha, ...

In prior posts, I've gone over some methods to prevent cycles from being added to your database.  However, imagine that someone has hand...

So, this question came up on IRC today: "How can I take a one-week date range, and have each date in a separate column?" This ...

So ... you're using some of 9.4's new advanced aggregates, including FILTER and WITHIN GROUP.  You want to take some statistical sam...

Primary Keyvil was one of the most popular posts on my old blog.  Since the old block has become somewhat inaccessible, and I recently did m...

I have a data analytics project which produces multiple statistical metrics for a large volume of sensor data.  This includes percentiles (l...

Since the folks at Tilt.com aren't on Planet Postgres, I thought I'd link their recent blog post on cool data migration hacks .  Til...

Here's one which just came up:  how to see all of the elements in a new array which were not in the old array.  This isn't currently...

Searching Google, I was surprised to find that there were few solutions published for a common issue: preventing users from creating a cycle...

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...

So a couple weeks ago I ran a little contest to see who could come up with a slogan for PostgreSQL 9.4.  Surprisingly, we got over 300 votes...

Now, you'll note in part I that I said that doing certain ALTER operations was "free", in quotes.  That's because these o...

One of PostgreSQL's headline features -- at least, compared to other relational databases -- is the ability to do some ALTER TABLE ALTER...

One of the things which usually happens on the rare occasions when you have PostgreSQL database corruption is that indexes become corrupted ...

So, here's the situation:  you want to create a report which shows totals of registrations by day and by category, and shows zeros for e...