Database Soup
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

About Me

Josh Berkus
View my complete profile
Powered by Blogger.