Postgres Weekly Issue 1
March 13, 2013
Welcome to the show..
Welcome to issue 1 of Postgres Weekly, a newsletter dedicated to the popular open source database system, PostgreSQL. Heroku's Craig Kerstiens, a veritable Postgres expert and fan, will be your chief curator.
The goal is to keep you up to date with Postgres news and the most interesting articles or techniques of the week without overloading you, so each issue will have only a handful of items. If you want to recommend anything for a future issue, tweet @craigkerstiens and he'll consider it.
This week
Open Source Release: postgresql-hll
Aggregate Knowledge released Postgres HyperLogLog, which is a new Postgres datatype hll that strikes a balance between HyperLogLog and a simple set. This data type solves the problem of calculating uniques for a given data set efficiently both in performance and storage.
How I Work with Postgres: psql, My PostgreSQL Admin
A common question for anyone new or even experienced with Postgres is whats the best editor out there? Most when they are asking this are asking for a GUI editor, this post highlights much of the power in the CLI 'psql' editor.
Handling Growth with Postgres: 5 Tips From Instagram
Instagram runs one of the largest publicly known around Postgres databases. Here's 5 straightforward tips from them to help with performance and scaling, which can be valuable for running any size database.
Postgres: The Bits You Haven't Found
A slide-deck from a presentation at Heroku's Waza conference that highlights many of the more unknown and rare features within Postgres, including 'WITH', arrays, pub/sub, and hstore.
Analyzing PostgreSQL Email Archives with PostgreSQL
Postgres has powerful full text search capabilities. In this article CitusDB highlights some of this power by examining the archives of the Postgres mailing list. One result of this analysis highlights just what a beast the maintainer of Postgres, Tom Lane, truly is.
Aggregations with Pg Hstore
HStore is the often unknown, but 'sexy' key-value store datatype within Postgres. This article from 2012 highlights how you can get even more power out of it through aggregating with some simple but powerful functions.