---
title: "This Week's PostgreSQL News (#129)"
publication: "Postgres Weekly"
issue: 129
published_at: "2015-10-28"
canonical_url: "https://postgresweekly.com/issues/129"
---

Postgres Weekly 129   . 

[Read this on the Web](http://postgresweekly.com/issues/129) 

[Postgres Weekly](http://postgresweekly.com) Issue 129 — October 28, 2015     

[PostgreSQL on the Command Line](http://phili.pe/posts/postgresql-on-the-command-line/?utm_source=postgresweekly&utm_medium=email)Many lament the lack of a graphical editor for Postgres but it does ship with a very powerful CLI editor in psql and spending a little time learning its ins and outs can make you very efficient. Philipe Fatio [How to Use Parameter Names in SQL Functions](https://tech.zalando.com/blog/how-to-use-parameter-names-in-sql-functions/?utm_source=postgresweekly&utm_medium=email)You can pack a lot of logic into Postgres if you choose to with the use of Postgres functions. And while not always the easiest thing to read and reason about in part because variables were named by position, as of several releases ago there is a better option for naming variables in functions. Zalando#tutorial [Real-time Postgres performance monitoring](http://dtdg.co/1OhYXXg)You need to know about performance issues before your end users do. With Datadog's turnkey Postgres integration, you can start collecting metrics in minutes, graph them alongside custom application metrics, and implement sophisticated alerts. [Sign up for your free trial here!](http://dtdg.co/1OhYXXg) Datadog#sponsored[![\](https://copm.s3.amazonaws.com/031be310.png)](http://dtdg.co/1OhYXXg) [Postgresql Table Partitioning](http://sheeju.github.io/2015/10/postgres-table-partitioning-big-weather-table.html?utm_source=postgresweekly&utm_medium=email)At some scale data in a single table in Postgres will reach limits. For most applications this is never a problem, but if it is there’s a number of options. Table partitioning isn’t necessarily ideal, but it can get the job done. sheeju.​github.​io#code [gpdb: Pivotal Greenplum Database](https://github.com/greenplum-db/gpdb?utm_source=postgresweekly&utm_medium=email)Greenplum, a massively parallel processing database, is one of many databases that starts with Postgres then builds and extends on it. It’s now fully open source so if you need it you can take a look and give it a spin and possibly even contribute. Pivotal#code [Porting ActiveRecord's "counter cache" Behavior to Postgres](http://shuber.io/porting-activerecord-counter-cache-behavior-to-postgres/?utm_source=postgresweekly&utm_medium=email)Many times it makes sense to have the same validation at your database as you do in some higher level framework, or maybe you want to use the database directly. Here’s a nice example that shows a bit what’s possible with rails counter_cache as an example. shuber.​io [What PostgreSQL has over other open source SQL databases: Part II](https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases-part-ii/?utm_source=postgresweekly&utm_medium=email)Postgres has a laundry list of features that sets it apart from other databases. In part two of the series check out a long list of awesome functionality including it’s indexing types, CTEs, and much more. If anyone needs to be persuaded to try Postgres this should do it. compose.​io [Moebius: A functional query tool for Elixir and Postgres](https://github.com/robconery/moebius?utm_source=postgresweekly&utm_medium=email)A library for performing functional style queries on Postgres from Elixir. Rob Conery#code [Want to spend less time job searching? Apply to the best startups in 60 seconds.](https://underdog.io/?utm_source=postgresweekly&utm_medium=email&utm_content=spendlesstime&utm_campaign=q4_15)If you’re accepted, startup decision-makers will email you as soon as next Monday. You decide where to interview and where to work. Now open in SF, NYC, and remote. Join the Underdog.io platform today! Underdog.​io#job#sponsored    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/129) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK