---
title: "#209: Postgres 10's New Features with Examples"
publication: "Postgres Weekly"
issue: 209
published_at: "2017-05-31"
canonical_url: "https://postgresweekly.com/issues/209"
---

Postgres Weekly 209   . 

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

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

[Postgres 10's New Features with Examples [PDF\]](http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_10_New_Features_en_20170522-1.pdf?utm_source=postgresweekly&utm_medium=email)A 101 page PDF from Hewlett Packard aimed at existing Postgres users keen to see the key differences between 9.6 and 10 Beta 1, complete with actual examples. Noriyoshi Shinoda [The Future of Postgres-XL](https://blog.2ndquadrant.com/future-of-postgres-xl/?utm_source=postgresweekly&utm_medium=email)Postgres-XL has been around for a number of years and now it's looking to grow its community, part of that is a switch to GitHub. Tomas Vondra#news [2ndQPostgres: Supercharged PostgreSQL for your Enterprise](https://www.2ndquadrant.com/en/resources/2ndqpostgres/)Offered exclusively to 2ndQuadrant customers, 2ndQPostgres includes carefully selected, quality-assured features not yet available in the community version of PostgreSQL - giving you access to cutting-edge features with no lock-in. 2ndQuadrant PostgreSQL Products#sponsored[![\](https://copm.s3.amazonaws.com/913e4a43.jpg)](https://www.2ndquadrant.com/en/resources/2ndqpostgres/) [Back from PGCon 2017: A Brief Report](https://afiskon.github.io/pgcon2017.html?utm_source=postgresweekly&utm_medium=email) Aleksander Alekseev#news [Connecting to Remote Spatial Data Sources with ogr_fdw](https://www.openscg.com/2017/05/connecting-to-remote-spatial-data-sources-with-ogr_fdw/?utm_source=postgresweekly&utm_medium=email)OGR allows access to a large number of GIS data formats and [ogr_fdw](https://github.com/pramsey/pgsql-ogr-fdw) brings support to Postgres 9.3+. Holly Orr [Speeding up Postgres Index Scans with Index-Only Scans](http://malisper.me/speeding-up-postgres-index-scans-with-index-only-scans/?utm_source=postgresweekly&utm_medium=email)[Michael Malis](http://malisper.me/) has been on an awesome streak recently with Postgres content, nearly at a post a day, this one highlights how index-only scans can give you much better performance. Michael Malis [Logical Replication in PostgreSQL 10](https://www.opsdash.com/blog/postgresql-logical-replication-howto.html?utm_source=postgresweekly&utm_medium=email) RapidLoop [PGObserver: A Postgres Monitoring Tool](http://zalando.github.io/PGObserver/?utm_source=postgresweekly&utm_medium=email)PGObserver is an open source tool to help you monitor your Postgres database. It’ll provide insights for stored procedures, IO stats, index usage, and much more, Zalando#tools [AgensGraph: A Multi-Model Graph Database Built on Postgres](http://www.agensgraph.com/?utm_source=postgresweekly&utm_medium=email)A multi-model graph database, built on top of Postgres, for modern complex data environments which supports relational and graph data models at the same time. Bitnine Global, Inc.​ #tools [Linux cloud hosting starting at 1GB of RAM for $5/mo.](http://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account. linode#sponsored [pg_squeeze: An Extension for Automatic Bloat Cleanup](https://github.com/cybertec-postgresql/pg_squeeze?utm_source=postgresweekly&utm_medium=email) Cybertec Schönig#tools    

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