---
title: "#232: Five Novelties in PostgreSQL 10"
publication: "Postgres Weekly"
issue: 232
published_at: "2017-11-08"
canonical_url: "https://postgresweekly.com/issues/232"
---

Postgres Weekly 232   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 232 — November 8, 2017     

[Postgres: The Non-Code Bits](http://www.craigkerstiens.com/2017/10/31/postgres-the-non-code-bits/)We link to a lot of technical articles on how Postgres works — this one talks a little more on all the _other_ facets of Postgres. Craig Kerstiens [Five Novelties in PostgreSQL 10](https://10clouds.com/blog/postgresql-10/)A look at some new PG 10 features including native partitioning and multicolumn statistics. Jakub Wilkowski [Migrating Large PostgreSQL Columns to DynamoDB](https://build.affinity.co/migrating-large-postgresql-columns-to-dynamodb-4af413cf5f5d)How CRM service Affinity moved a large volume of data to a “more suitable datastore” given their query patterns. Rohan Sahai [Accelerate Your Implementation with a Proven Reference Architecture](https://www.enterprisedb.com/services/enterprise-readiness-service)Accelerate the implementation of your EDB Postgres solution with our Enterprise Readiness Service. We will help you plan and deploy an optimized Postgres implementation, customized to your needs and your environment. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/d35c14b4.png)](https://www.enterprisedb.com/services/enterprise-readiness-service) [Book: Mastering PostgreSQL in Application Development](http://masteringpostgresql.com/)A new (paid) book by a PG committer that’s aimed not at DBAs but application developers who want to master Postgres. Dimitri Fontaine#news [Google's Cloud SQL for Postgres Adds High Availability/Replication](https://cloudplatform.googleblog.com/2017/11/Cloud-SQL-for-PostgreSQL-adds-high-availability-and-replication.html)Google’s cloud SQL service has improves its Postgres offering with support for high availability and read replicas, plus instances with up to 416GB of RAM. Google Cloud Platform#news [Implementing Stripe-Like Idempotency Keys in Postgres](https://brandur.org/idempotency-keys)Less of a blog post and more of a small novel on how to implement your own idempotent API keys directly in Postgres. All of it is a great read. Brandur Leach [Deep Dive Into Postgres Stats: pg_stat_progress_vacuum](http://blog.postgresql-consulting.com/2017/10/deep-dive-into-postgres-stats_31.html)Postgres keeps a lot of information about your database in some of its stats tables. This post walks us through some of the details it retains about vacuum. Alexey Lesovsky [Partition and Conquer a Large Postgres Table](https://evilmartians.com/chronicles/partition-and-conquer)How to perform partitioning of a large table that’s actively used in production with a Ruby on Rails application and not lose any data. Sergey Dolganov and Denis Lifanov [Understanding Caching in Postgres: An In-Depth Guide](https://madusudanan.com/blog/understanding-postgres-caching-in-depth/)An oldie but still goodie on all you need to know about how caching in Postgres works. Madusudanan B N [Time Series Database Internals – InfluxDB](https://www.influxdata.com/blog/influxdb-internals-101-part-one/)Learn how we built the fastest growing open source TSDB. InfluxData#sponsored    

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