---
title: "This Week's PostgreSQL Treats (#1)"
publication: "Postgres Weekly"
issue: 1
published_at: "2013-03-13"
canonical_url: "https://postgresweekly.com/issues/1"
---

Postgres Weekly Issue 1 - March 13, 2013

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/1)**Postgres Weekly****Issue 1**
March 13, 2013Welcome to the show..Welcome to issue 1 of _Postgres Weekly_, a newsletter dedicated to the popular open source database system, [PostgreSQL](http://www.postgresql.org/). Heroku's [Craig Kerstiens](https://twitter.com/craigkerstiens), 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](https://twitter.com/craigkerstiens) and he'll consider it.This week[Open Source Release: postgresql-hll](http://blog.aggregateknowledge.com/2013/02/04/open-source-release-postgresql-hll/?utm_source=postgresweekly&utm_medium=email)Aggregate Knowledge released Postgres HyperLogLog, which is a new Postgres datatype hll that strikes a balance between [HyperLogLog](http://blog.aggregateknowledge.com/2012/10/25/sketch-of-the-day-hyperloglog-cornerstone-of-a-big-data-infrastructure/) and a simple set. This data type solves the problem of calculating uniques for a given data set efficiently both in performance and storage.[![\](http://s3.amazonaws.com/nlga/uploads/item/image/9376/thumb_uniquesovertime.png)](http://blog.aggregateknowledge.com/2013/02/04/open-source-release-postgresql-hll/?utm_source=postgresweekly&utm_medium=email)[How I Work with Postgres: psql, My PostgreSQL Admin](http://craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/?utm_source=postgresweekly&utm_medium=email)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](http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram?utm_source=postgresweekly&utm_medium=email)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](http://postgres-bits.herokuapp.com/?utm_source=postgresweekly&utm_medium=email)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](http://citusdata.com/blog/57-postgresql-full-text-search?utm_source=postgresweekly&utm_medium=email)Postgres has powerful full text search capabilities. In this article [CitusDB](http://www.citusdata.com/) 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](http://big-elephants.com/2012-10/aggregations-with-pg-hstore/?utm_source=postgresweekly&utm_medium=email)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.Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)