---
title: "This Week's PostgreSQL News (#202)"
publication: "Postgres Weekly"
issue: 202
published_at: "2017-04-12"
canonical_url: "https://postgresweekly.com/issues/202"
---

Postgres Weekly 202   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 202 — April 12, 2017     

[A Runthrough of Features Coming in Postgres 10](http://rhaas.blogspot.com/2017/04/new-features-coming-in-postgresql-10.html?utm_source=postgresweekly&utm_medium=email)Robert Haas is impressed with how Postgres is shaping up. Here he presents some brief summaries on the key features on the way including declarative partitioning and durable hash indexes. Robert Haas#news [Working With Postgres at Scale: Query Performance and Autovacuuming for Large Tables](https://medium.com/contactually-engineering/postgres-at-scale-query-performance-and-autovacuuming-for-large-tables-d7e8ad40b16b?utm_source=postgresweekly&utm_medium=email)How a team discovered query performance slippage issues on their largest tables (up to billions of rows) and what they did to address it. John Gerhardt#tutorial [Define the Future of Postgres & Open Source Data Management](http://www.postgresvision.com/)Explore innovation in open source data management at Postgres Vision, Boston June 26-28. Use Cases from IAG, MasterCard, TripAdvisor, and more. Save $200 - use code `PGWEEK` by May 19. Postgres Vision 2017#sponsored[![\](https://copm.s3.amazonaws.com/70ab1db2.png)](http://www.postgresvision.com/) [PGCon 2017 (Ottawa, Canada, May 23-26) Registration Open](http://www.pgcon.org/2017/registration.php?utm_source=postgresweekly&utm_medium=email)Note: the link to start registration is at the bottom of the page. PGCon#news [Deep Dive Into Postgres Stats: pg_stat_replication](http://blog.postgresql-consulting.com/2017/04/deep-dive-into-postgres-stats.html?utm_source=postgresweekly&utm_medium=email)A useful stat for checking replication lag. A must see if you’re using streaming replication. Alexey Lesovsky#tutorial [How To Deploy Postgres on Kubernetes](https://www.xenonstack.com/blog/how-to-deploy-postgresql-on-kubernetes?utm_source=postgresweekly&utm_medium=email) Xenonstack#tutorial [How to Build a Node.js API using Postgres, Lambda and API Gateway](https://medium.com/@peterhanssens/how-to-build-a-node-js-api-using-postgres-lambda-and-api-gateway-3211a4570cea?utm_source=postgresweekly&utm_medium=email) Peter Hanssens#tutorial [Getting a 150x Speedup for Real-Time Dashboards on 9.5](https://blog.getbotmetrics.com/150x-speedup-in-real-time-dashboards-with-postgres-9-5-2e987a5b906e?utm_source=postgresweekly&utm_medium=email)Using features such as triggers, upserts and queues. Arun Thampi [Try real-time Postgres monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeekly)Identify unoptimized queries and overloaded dbs automatically with machine-learning powered alerts Datadog#tools#sponsored [PgComment: A Schema Commenting Tool for Windows](https://www.postgresql.org/about/news/1740/?utm_source=postgresweekly&utm_medium=email)A Windows-based tool for viewing your schemas and to leave comments on them or even individual columns and functions. Yohz Software#tools [jpgAgent: A Postgres Job Scheduler](https://github.com/GoSimpleLLC/jpgAgent?utm_source=postgresweekly&utm_medium=email)Written in Java and aiming to be compatible with pgAgent. Adam Brusselback#tools    

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