---
title: "#226: PostgreSQL 10 RC1 Released"
publication: "Postgres Weekly"
issue: 226
published_at: "2017-09-27"
canonical_url: "https://postgresweekly.com/issues/226"
---

Postgres Weekly 226   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 226 — September 27, 2017     

[PostgreSQL's Hash Indexes Are Now Cool](http://rhaas.blogspot.co.uk/2017/09/postgresqls-hash-indexes-are-now-cool.html?utm_source=postgresweekly&utm_medium=email)Before Postgres 10, hash indexes were severely flawed but things are turning around fast as Robert explains here. Robert Haas [PostgreSQL 10 RC1 Released](https://www.postgresql.org/about/news/1783/?utm_source=postgresweekly&utm_medium=email)The first release candidate of version 10 is now available for download. PostgreSQL.​org#news [pglogical 2.0 - The next generation of logical replication from 2ndQuadrant](https://www.2ndquadrant.com/en/resources/pglogical/)pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. Replicate your data with this alternative to physical replication & achieve zero-downtime. 2ndQuadrant PostgreSQL Products#sponsored[![\](https://copm.s3.amazonaws.com/5016eca7.jpg)](https://www.2ndquadrant.com/en/resources/pglogical/) ['The Day I Reached The 1600 Columns Limit in Postgres'](https://rosenfeld.herokuapp.com/en/articles/programming/2017-09-26-the-day-i-reached-the-1600-columns-limit-in-postgresql?utm_source=postgresweekly&utm_medium=email)Postgres doesn’t reclaim space when dropping a column which can be a problem in situations where you create and remove many temporary columns.. An interesting story. Rodrigo Rosenfeld Rosas [What's New in Postgres 10](https://wiki.postgresql.org/wiki/New_in_postgres_10?utm_source=postgresweekly&utm_medium=email)A laundry list of changes in the forthcoming new major version of Postgres. PostgreSQL Wiki#news [Unit Testing Postgres with the pgTAP Framework](https://medium.com/engineering-on-the-incline/unit-testing-postgres-with-pgtap-af09ec42795?utm_source=postgresweekly&utm_medium=email) Simon McClive [Migrating From Single-Node Postgres to Citus](https://www.citusdata.com/blog/2017/09/20/migrating-from-single-node-postgres-to-citus/?utm_source=postgresweekly&utm_medium=email)Some steps to follow for migration to Citus. Craig Kerstiens [Multi-Dimensional Choropleth Maps using PostGIS, GeoServer, and Google Earth](https://medium.com/@aliasmrchips/multi-dimensional-choropleth-maps-using-postgis-geoserver-and-google-earth-557a03608c99?utm_source=postgresweekly&utm_medium=email) Mark Mathis [Taming Postgres Autovacuum](https://developer.s24.com/blog/taming-postgresql-autovacuum.html?utm_source=postgresweekly&utm_medium=email)When tuning autovacuum, ‘start with the default settings and check table bloat regularly’. Torsten Bøgh Köster [Transactionally Staged Job Drains in Postgres](https://brandur.org/job-drain?utm_source=postgresweekly&utm_medium=email)Building a robust background worker system that leverages transactional isolation to never work a job too early, and transactional durability to never let one drop. Brandur Leach [Bridging the PostgreSQL Chasm](https://www.commandprompt.com/blog/postgres%20chasm/?utm_source=postgresweekly&utm_medium=email)_“What I see lacking as a whole with PostgreSQL is effective communication and outreach to engage and onboard new users and developers.”_ Debbie Cerda#opinion [Dive deeper into your Postgres database with SelectStar](https://selectstar.io/blog/postgresql-selectstar-database-performance-platform/?utm_source=sponsored&utm_medium=email&utm_campaign=9+27+2017+Postgres+Weekly)Start a free trial and see how advanced queries help optimize performance. SelectStar#sponsored [Podyn: DynamoDB to Postgres Replication and Migration Tool](https://www.citusdata.com/blog/2017/09/22/dynamodb-to-postgres-replication/?utm_source=postgresweekly&utm_medium=email) Marco Slot#tools    

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