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

Postgres Weekly 156   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 156 — May 11, 2016     

[PostgreSQL Scalability: Towards 1 Million TPS](http://akorotkov.github.io/blog/2016/05/09/scalability-towards-millions-tps/?utm_source=postgresweekly&utm_medium=email)While Postgres becomes more usable with every release, it’s also made big performance improvements. Take a look at how close Postgres is to hitting one million transactions per second. Alexander Korotkov#news [PGDay UK 2016 (in London on July 5)](http://www.pgconf.uk/?utm_source=postgresweekly&utm_medium=email)The UK’s only dedicated PostgresSQL annual user conference returns in July. Early bird tickets are still available. PostgreSQL UK Usergroup#news [Beating Uber with A PostgreSQL Prototype](http://www.cybertec.at/2016/05/beating-uber-with-a-postgresql-prototype/?utm_source=postgresweekly&utm_medium=email)How to beat the latency of Uber’s geo-fencing query by just using nice PostgreSQL code and 30 minutes of programming time. Hans-Juergen Schoenig#tutorial [Postgres Training for Developers - Buy 1, Get 1 Free Offer](http://www.enterprisedb.com/store/products/dba-training?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016MayDevBOGO)Want to learn/expand your development skills for Postgres? Buy one of our Postgres Developer Training online courses (Fundamentals on May 23-24 or Advanced on May 25-26) and you will get the other course for free. Contact us today to take advantage of this special offer. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/7b6fa94b.png)](http://www.enterprisedb.com/store/products/dba-training?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016MayDevBOGO) [Seldom Used PG Functions: bool_or and bool_and](http://neovintage.org/2016/05/04/the-bool-aggregate-functions/?utm_source=postgresweekly&utm_medium=email)Postgres has a wealth of functions that can make your life easier. Highlighted here are two boolean aggregation functions for checking conditions across a dataset. Rimas Silkaitis#tutorial [Multi-Table Full Text Search in Postgres](http://calebthompson.io/talks/search.html?utm_source=postgresweekly&utm_medium=email)Basic search over a single column can be simple, and expanding it across multiple columns isn’t much more effort. These slides walk you through getting up and running. Caleb Thompson#tutorial [Deploying Django + Python 3 + PostgreSQL to AWS Elastic Beanstalk](https://realpython.com/blog/python/deploying-a-django-app-and-postgresql-to-aws-elastic-beanstalk/?utm_source=postgresweekly&utm_medium=email) Real Python#tutorial [Teleport: A Trigger-Based Postgres Replicator Written in Go](https://github.com/pagarme/teleport?utm_source=postgresweekly&utm_medium=email)A trigger-based replicator that performs DDL migrations by diffing schema changes and replicating real-time data changes based on DML triggers. No special permissions required, so it’s suitable for AWS RDS. Pagar.​me#tools [Access to the Best PostgreSQL Support Team](http://2ndquadrant.com/en/support/rdba/)Our Remote DBA service connects you with the leading and most experienced PostgreSQL experts, who regularly contribute to core PostgreSQL development. 2ndQuadrant.​com#sponsored    

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