#postgres

When to throw `IN` out

May 23, 2018
#postgres
#tech
#database
Using IN is convenient, but can easily slow down your queries. Here's how to get around it!

Upgrade a Heroku shared database to Postgres 9.1 dev plan

June 6, 2012
#db
#postgres
#tech
#heroku
I just upgraded one of our sites on Heroku to Postgres 9.1. Here's how I did it.

Postgres parallel restore is dramatically faster

December 7, 2011
#postgres
#tech
Summary: Use pg_restore -j number-of-jobs to restore an "archive format" dump in parallel.

Stored Procedure Information In PostgreSQL

January 7, 2008
#stored-procedures
#sql
#postgres