---
title: "#206: When Postgres Is Not Enough"
publication: "Postgres Weekly"
issue: 206
published_at: "2017-05-10"
canonical_url: "https://postgresweekly.com/issues/206"
---

Postgres Weekly 206   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 206 — May 10, 2017     

[Building JSON API Responses With Postgres CTEs](http://www.codedependant.net/2017/04/30/build-json-api-responses-postregres-with-cte/?utm_source=postgresweekly&utm_medium=email)A neat demonstration of using common table expressions to provide extra assistance to other queries. Eric Satterwhite [When Postgres Is Not Enough](https://medium.com/goiabada/when-postgres-is-not-enough-237b723be442?utm_source=postgresweekly&utm_medium=email)Postgres is great but it doesn’t solve _all_ data problems. Here’s a balanced perspective of how Postgres wasn’t working in every aspect for one team, but still remained a key part of their stack. Leonardo Brito#opinion [Scaling Connections in Postgres](https://www.citusdata.com/blog/2017/05/10/scaling-connections-in-postgres/?utm_source=postgresweekly&utm_medium=email)One issue that comes when running Postgres at a high scale is managing large numbers of database connections. Here we see how to assess your connection count number and what to do about it. citusdata [How One Preschool is using PostgreSQL and Redis on Compose](https://compose.com/articles/one-preschool-making-the-most-of-compose/?utm_source=cooper&utm_medium=newsletter&utm_content=postgres)One Preschool is making preschooling both accessible and practical throughout the world. We spoke with them to hear about their startup, mission and how they are using Compose hosted PostgreSQL and Redis to make this happen. Compose#sponsored[![\](https://copm.s3.amazonaws.com/be1058d5.png)](https://compose.com/articles/one-preschool-making-the-most-of-compose/?utm_source=cooper&utm_medium=newsletter&utm_content=postgres) [Testing Huge PostgreSQL Backups for 37 Cents a Day](https://feedbin.com/blog/2017/05/05/testing-huge-postgresql-backups-for-37-cents-a-day/?utm_source=postgresweekly&utm_medium=email)Some clever rigging up of [WAL-E](https://github.com/wal-e/wal-e), S3, and EC2 for backing up a Postgres database and then testing that it restores correctly every day. Ben Ubois [Schedule for PGDay UK 2017 (July 3-4, London)](http://www.pgconf.uk/schedule?utm_source=postgresweekly&utm_medium=email)PGDay UK is coming up again in several weeks - the schedule is live and if you’re in Europe it’s worth checking out. PGDay UK#news [Amazon RDS for Postgres Now Supports Minor Versions 9.6.2, 9.5.6, 9.4.11 and 9.3.16](https://aws.amazon.com/about-aws/whats-new/2017/05/amazon-rds-postgresql-version-support/?utm_source=postgresweekly&utm_medium=email) Amazon Web Services#news [Deep Dive Into Postgres Stats: pg_stat_all_tables](http://blog.postgresql-consulting.com/2017/04/deep-dive-into-postgres-stats_20.html?utm_source=postgresweekly&utm_medium=email)In the continuing series about Postgres stats is a look at data Postgres keeps about sequential scans and autovacuum. Alexey Lesovsky [Who Contributes to Postgres Development?](http://rhaas.blogspot.com/2017/04/who-contributes-to-postgresql.html?utm_source=postgresweekly&utm_medium=email)Robert Haas went through Postgres’ 2016 commit log to see who the biggest contributors to the project are. Robert Haas [A Postgres Response to Uber [PDF\]](http://thebuild.com/presentations/uber-perconalive-2017.pdf?utm_source=postgresweekly&utm_medium=email)Last year Uber switched from Postgres to MySQL, here Christophe Pettus goes through the reasons why. Christophe Pettus [Benchmarking Complex Query Performance in CrateDB vs Postgres](https://crate.io/a/benchmarking-complex-query-performance-cratedb-postgresql/?utm_source=postgresweekly&utm_medium=email)The benchmarks are by the Crate team themselves, but the [open source distributed SQL database](https://github.com/crate/crate) may be worth investigating for certain use cases. CrateDB#opinion [pglogical 2.0: Logical Replication as a PostgreSQL Extension](https://2ndquadrant.com/en/about/news/announcing-release-pglogical-20/?utm_source=postgresweekly&utm_medium=email) 2ndQuadrant#tools [PostGraphQL: Create GraphQL Schemas from Postgres Schemas](https://github.com/postgraphql/postgraphql?utm_source=postgresweekly&utm_medium=email) PostGraphQL#tools [Support Modern Digital Apps & DevOps with Your Legacy IT](http://www.postgresvision.com)Hands-on workshops, DBA/developer tracks at Postgres Vision. Attend for $200 off with code PGWEEK by May 19. Postgres Vision 2017#sponsored    

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