#232: Five Novelties in PostgreSQL 10

.

Read this on the Web

Postgres Weekly Issue 232 — November 8, 2017

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 A look at some new PG 10 features including native partitioning and multicolumn statistics. Jakub Wilkowski Migrating Large PostgreSQL Columns to DynamoDB 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 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  Book: Mastering PostgreSQL in Application Development 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 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 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 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 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 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 Learn how we built the fastest growing open source TSDB. InfluxData    #sponsored  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK