Tuesday, March 31, 2015
Primary Keyvil, reprised
›
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...
11 comments:
Saturday, March 28, 2015
Crazy SQL Saturday: replacing SciPy with SQL
›
I have a data analytics project which produces multiple statistical metrics for a large volume of sensor data. This includes percentiles (l...
Thursday, March 19, 2015
PostgreSQL data migration hacks from Tilt
›
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...
Monday, March 16, 2015
Benchmarking Postgres in the Cloud, part 1
›
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-...
6 comments:
Friday, March 6, 2015
Fancy SQL Friday: subtracting arrays
›
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...
4 comments:
Thursday, February 26, 2015
Why you might need statement_cost_limit
›
Here's a commonplace ops crisis: the developers push a new dashboard display widget for user homepages on your application. This seems ...
4 comments:
Tuesday, February 17, 2015
Spring/Summer 2015 Conference Schedule
›
What follows is my conference travel schedule through the early summer. I'm posting it so that local PUGs will know when I'm going ...
‹
›
Home
View web version