---
title: "This Week's PostgreSQL News (#43)"
publication: "Postgres Weekly"
issue: 43
published_at: "2014-01-22"
canonical_url: "https://postgresweekly.com/issues/43"
---

Postgres Weekly Issue 43 - January 22, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/43)**Postgres Weekly****Issue 43**
January 22, 2014[Postgres 9.4 Feature Highlight: ALTER SYSTEM SET for Dynamic Configuration](http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-alter-system-set-for-dynamic-configuration/?utm_source=postgresweekly&utm_medium=email)While you could modify many config settings for a specific database, in 9.4 with some new new SQL commands you’ll be able to modify the configuration of the Postgres server itself._Michael Paquier_[PostgreSQL Conference New York - April 3-4, 2014](http://nyc.pgconf.us/2014/schedule/?utm_source=postgresweekly&utm_medium=email)PGConf NYC 2014 focuses on how people use PostgreSQL, from the perspective of developers, DBAs, systems administrators, and decision makers. The schedule for the site is now live, take a look at the talks and make sure to register._PGConf NYC 2014_[Understanding Postgres Parameter Context](http://gurjeet.singh.im/blog/2014/01/07/understanding-postgres-parameter-context/?utm_source=postgresweekly&utm_medium=email)There’s a variety of controls within Postgres, each of these have different times and opportunities where they can be modified. Here’s a great simple overview into them._Gurjeet Singh_[SQL for Reporting Queries](https://gist.github.com/selenamarie/8544201?utm_source=postgresweekly&utm_medium=email)A collection of Postgres queries by [@selenamarie](http://www.twitter.com/selenamarie) that highlights some of the more powerful as well as useful features including CTEs, JSON, HyperLogLog, and Window functions._Selena Deckelmann_[Woolly: A Mac GUI for Postgres](https://itunes.apple.com/us/app/woolly/id713705962?mt=12?utm_source=postgresweekly&utm_medium=email)There continues to be more and more in the line of admin interfaces for Postgres, clearly attempting to address the hole of quality ones. Here’s yet another attempt for Mac._Mac App Store_[Constructing Escape-Time Fractals with PostgreSQL](http://explainextended.com/2013/12/31/happy-new-year-5/?utm_source=postgresweekly&utm_medium=email)While not overly practical here’s a few really fun queries showing just how expressive you can be in SQL._Explain Extended_[DB Doc 1.0: Postgres Database Documentation Tool](http://www.yohz.com/dbdoc_overview.htm?utm_source=postgresweekly&utm_medium=email)Commercial software (with a trial) that documents your server’s properties, settings, and database objects._Yohz Software_From our sponsor[Heroku Postgres - Fully managed Postgres on EC2](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)Heroku Postgres is the worlds largest provider of Postgres as a Service, offering fully managed databases on top of EC2. Get started today for free and scale easily as your application needs to.[![\](http://s3.amazonaws.com/nlga/uploads/item/image/10726/thumb125_125x125-build-more-blue.png)](https://postgres.heroku.com/?utm_source=postgresweekly=email=emailbanner?utm_source=postgresweekly&utm_medium=email)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|*)