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

Postgres Weekly 92   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 92 — February 11, 2015     

[PostgreSQL 9.4.1, 9.3.6, 9.2.10, 9.1.15 & 9.0.19 Released](http://www.postgresql.org/about/news/1569/?utm_source=postgresweekly&utm_medium=email)Not feature releases, but important updates with fixes for multiple security issues. Postgresql.​org#news [Modern SQL in PostgreSQL](http://www.slideshare.net/MarkusWinand/modern-sql?utm_source=postgresweekly&utm_medium=email)SQL gets a lot of flack for not being new and updated and, well, fun. But the truth is it’s come a long way from what it was decades ago. Here’s a great deck which highlights some of the new and awesome things in the SQL standard. Markus Winand [Realtime Updates From PostgreSQL to Elasticsearch](https://developer.atlassian.com/blog/2015/02/realtime-requests-psql-elasticsearch/?utm_source=postgresweekly&utm_medium=email)A quick explanation of how to perform event-driven updates from a PostgreSQL instance to Elasticsearch, the search index server. Atlassian Developers#tutorial [Performance Tuning – A Methodical Approach for the Multi-Tasker](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafUAAQ?utm_source=postgresweekly&utm_medium=email)Knowing you have wide range of skill demands in your role as a Postgres DBA, it pays to invest some time in learning effective techniques for performance tuning, an essential task that arises time and time again. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/b9ffffaf.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafUAAQ?utm_source=postgresweekly&utm_medium=email) [Some Notes on The Update Releases](http://www.databasesoup.com/2015/02/some-notes-on-todays-update-release.html?utm_source=postgresweekly&utm_medium=email)Last Thursday there were new releases of Postgres (above) addressing a few security issues among other items. Here’s a rundown of what’s included in the release which should help you know whether to update or not, though as always it’s a good practice to do. databasesoup.​com [The Awesome PostgreSQL 9.4 / SQL:2003 FILTER Clause for Aggregate Functions](http://blog.jooq.org/2014/12/30/the-awesome-postgresql-9-4-sql2003-filter-clause-for-aggregate-functions/?utm_source=postgresweekly&utm_medium=email)Turns out Postgres 9.4 supports a clause from SQL:2003 that not even Oracle does yet. Lukas Eder#tutorial [Counting Comma-Delimited Values in Postgres, MySQL, Amazon Redshift and MS SQL Server](https://www.periscope.io/blog/counting-comma-delimited-values-in-postgres-mysql-amazon-redshift-and-ms-sql-server.html?utm_source=postgresweekly&utm_medium=email)If you’ve got data you want to count but it's formatted as CSV, there’s a few ways to do it. Periscope#tutorial [Query JSON with Postgres 9.4 and Rails 4.2](http://robertbeene.com/rails-4-2-and-postgresql-9-4/?utm_source=postgresweekly&utm_medium=email) Robert Beene#tutorial [Basic PostgreSQL Backup and Restore](http://www.rubytreesoftware.com/resources/basic-postgresql-backup-and-restore?utm_source=postgresweekly&utm_medium=email)Here’s a quick guide along with a video walk through of the basics of backing up and restoring your PG database. And pro-tip: as is always the case with backups, unless you test them by restoring them then you shouldn’t rely on your backups. RubyTree Software#tutorial#video [django-watson: Full-text Multi-table Search App for Django](https://github.com/etianen/django-watson?utm_source=postgresweekly&utm_medium=email)If you want to add full text search without having to roll something else into your Django application, Django-watson is a full-text multi-table search application. Dave Hall#code [A Writable Foreign Data Wrapper for Redis](https://github.com/nahanni/rw_redis_fdw?utm_source=postgresweekly&utm_medium=email)Foreign data wrappers provide the powerful ability for you to query to something else from within your Postgres database. Here’s a newer one that not only lets you query to [Redis from inside Postgres](http://www.craigkerstiens.com/2012/10/18/connecting_to_redis_from_postgres/), but also write data out to it. Nahanni Systems#code [pgopher: A Static Binary to Run Postgres Commands](https://github.com/longnguyen11288/pgopher?utm_source=postgresweekly&utm_medium=email)Don’t want to have psql installed on a certain system? pgopher uses the pure Go Postgres driver to let you issue commands directly. Long Nguyen#code#tools    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/92) [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