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

Postgres Weekly Issue 90 - January 28, 2015

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/90)**Postgres Weekly****Issue 90**
January 28, 2015[Better Monitoring with pg_stat_archiver in PostgreSQL 9.4](http://linkis.com/blog.2ndquadrant.com/qhxHk?utm_source=postgresweekly&utm_medium=email)Postgres 9.4 introduced many improvements - one of the most exciting being JSONB. There’s also another key one that quietly snuck in that gives you more insight into where you’re at with your replication, helping you have more safety around your data._2ndQuadrant_[Abbreviated Keys: Exploiting Locality to Improve PostgreSQL's Text Sort Performance](http://pgeoghegan.blogspot.co.uk/2015/01/abbreviated-keys-exploiting-locality-to.html?utm_source=postgresweekly&utm_medium=email)_Peter Geoghegan_[SQL Runner: Run Playbooks of SQL Scripts in Series and Parallel](https://github.com/snowplow/sql-runner?utm_source=postgresweekly&utm_medium=email)Aimed at Amazon Redshift and PostgreSQL._Snowplow Analytics_[The Top 10 List for Planning a Postgres Deployment](http://blogs.enterprisedb.com/2015/01/09/10-steps-to-planning-your-postgres-deployment-part-1/?utm_source=cooperpress=nl=titop10jan28?utm_source=postgresweekly&utm_medium=email)A well-prepared DBA considers their strategy for a Postgres rollout early. Thinking about key database questions in advance can make you the IT hero as you reveal a solid deployment plan that directly supports the goals of the business._EnterpriseDBSponsored_[![\](https://copm.s3.amazonaws.com/b9ffffaf.png)](http://blogs.enterprisedb.com/2015/01/09/10-steps-to-planning-your-postgres-deployment-part-1/?utm_source=cooperpress=nl=titop10jan28?utm_source=postgresweekly&utm_medium=email)[How to Bulk-Import JSON to Postgres](http://www.prolificprogrammer.com/2015/01/the-script-above-imports-json-into.html?utm_source=postgresweekly&utm_medium=email)Got lots of JSON data sitting around? You can quickly load it into Postgres to do more analysis, which is even easier with JSONB now._Hasan Diwan_[Regular Expression Stop Words for Postgresql](http://no0p.github.io/postgresql/2015/01/24/postgresql-regexp-stopwords.html?utm_source=postgresweekly&utm_medium=email)If Postgres’ text parsing out of the box isn’t enough for you, you can simply plug in your own. Here’s an awesome example of parsing out stop words, which can come in handy in lots of use cases._no0p_[Read Scalability in PostgreSQL 9.5](http://amitkapila16.blogspot.jp/2015/01/read-scalability-in-postgresql-95.html?utm_source=postgresweekly&utm_medium=email)_Amit Kapila_[Incremental Backup with Barman 1.4.0](http://blog.2ndquadrant.com/incremental-backup-barman-1-4-0/?utm_source=postgresweekly&utm_medium=email)Barman, one of the two predominant solutions for disaster recovery (with the other being [Wal-e](https://github.com/wal-e/wal-e)), just got a major update, incremental backups which can help with both speed and size._2ndQuadrant_[Learning Bitmap Index Scan, Recheck Cond, and Bitmap Heap Scan](http://pglearner.blogspot.com/2015/01/learning-bitmap-index-scan-recheck-cond.html?utm_source=postgresweekly&utm_medium=email)Want to learn more about how things work under the covers? Here’s a guide into bitmap indexes and heap scans and what’s happening on SELECTs using them._Alex K_[CTEs and Window Functions: Unleashing the Power of Redshift](http://engineeringblog.yelp.com/2015/01/title-ctes-and-window-functions-unleashing-the-power-of-redshift.html?utm_source=postgresweekly&utm_medium=email)While not directly Postgres, Amazon’s Redshift is a fork of Postgres which retains many similarities. Some of its features are particularly interesting, two of which are shown off here._Yelp Engineering_[Job: SRE Position at DuckDuckGo (Remote OK)](https://duck.co/help/company/hiring?utm_source=postgresweekly&utm_medium=email)If you're an avid DuckDuckGo user and excited about what we're trying to accomplish, then please consider joining us!_DuckDuckGoJob_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|*)