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

Postgres Weekly 121   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 121 — September 2, 2015     

[10 Beginner's PostgreSQL Tasks You Should Know](https://eye.raze.mx/10-beginner-postgresql-tasks-you-should-know/?utm_source=postgresweekly&utm_medium=email)You may already be pretty knowledgable about Postgres, but if you’re still relatively new, here’s a good run down of 10 basic steps to help you get up and running. Jorge Raze [SQL vs NoSQL KO: Postgres vs Mongo](https://www.airpair.com/postgresql/posts/sql-vs-nosql-ko-postgres-vs-mongo?utm_source=postgresweekly&utm_medium=email)A thorough comparison of Postgres to Mongo (one of the predominant NoSQL databases). Instead of just performance benchmark fodder, this post does a great job helping educate about many of the differences along the way. Abraham Polishchuk [Efficient Storage Of Large IDs In Postgres](http://www.garysieling.com/blog/efficient-storage-of-large-ids-in-postgres?utm_source=postgresweekly&utm_medium=email)A look at using different column types to store large IDs (such as long hex string identifiers) more efficiently. Gary Sieling#tutorial [Unleash Real-Time Big Data on PostgreSQL](http://info.citusdata.com/BigDataPW.html)CitusDB delivers [real-time end user insights](http://info.citusdata.com/BigDataPW.html) into your big data while reducing the cost and complexity of your database infrastructure and leveraging your existing PostgreSQL knowledge and applications. Supports structured or unstructured data and [elastically scales.](http://info.citusdata.com/BigDataPW.html) Citus Data#sponsored[![\](https://copm.s3.amazonaws.com/1ea804a5.png)](http://info.citusdata.com/BigDataPW.html) [PostgreSQL Document API Part 4: Complex Queries](http://rob.conery.io/2015/09/01/postgresql-document-api-part-4-complex-queries/?utm_source=postgresweekly&utm_medium=email)Continuing with his series on using Postgres as a document store, Rob Conery now looks at how to create complex queries on documents, far beyond basic string matching. Rob Conery [Review of Operators in Postgres](http://bernardoamc.github.io/sql/2015/07/21/postgres-review-operators/?utm_source=postgresweekly&utm_medium=email)JSONB and Array are two very awesome and powerful datatypes in Postgres, but querying in to them may not be the most natural thing. Here’s the overview of key operators for working with each, a great handy guide if you’re already or looking to use those datatypes. Bernardo Chaves#code [Replication and Load Balancing with pgpool-ii](http://pjkh.com/articles/postgresql-replication-and-load-balancing-with-pgpool2/?utm_source=postgresweekly&utm_medium=email)Postgres has come along way with its replication story in recent years, but load balancing still requires a bit extra in terms of tooling. pgpool is one option - take a look at how to set it up here. Philip Hallstrom [pg-migrator: PostgreSQL Migration Tool](https://github.com/aphel-bilisim-hizmetleri/pg-migrator?utm_source=postgresweekly&utm_medium=email)A complete and easy to use command-line migration tool for PostgreSQL. Aphel Bilişim Hizmetleri#code [wal-e: Simple Continuous Archiving for Postgres](https://github.com/wal-e/wal-e?utm_source=postgresweekly&utm_medium=email)The most important task for your database is keeping your data safe, so continuous archiving is one of the tools every database should have. Wal-e is a simple tool for helping with that, and it powers continuous archiving for all of Heroku Postgres too. GitHub#code [postgres-backup-s3: Docker Container for PostgreSQL to S3 Backups](https://github.com/schickling/dockerfiles/tree/master/postgres-backup-s3?utm_source=postgresweekly&utm_medium=email) Johannes Schickling#tools [OSCON EU 2015: Amsterdam, October 26-28](http://www.oscon.com/open-source-eu-2015/?utm_source=postgresweekly&utm_medium=email)O'Reilly's OSCON open source conference is coming to Europe this October, featuring speakers like Douglas Crockford of PayPal and Leslie Hawthron of Elastic. There's a whole data track too. oscon.​com    

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