---
title: "#250: New Annotated Config Files for Postgres 10"
publication: "Postgres Weekly"
issue: 250
published_at: "2018-04-04"
canonical_url: "https://postgresweekly.com/issues/250"
---

The latest Postgres news, articles, tools, and projects.       

#250 — April 4, 2018 

[Read on the Web](https://postgresweekly.com/issues/250)   

Postgres Weekly  

[New Annotated Config Files for Postgres 10](http://www.databasesoup.com/2018/04/new-annotated-config-files-for.html) — [annotated.conf](https://github.com/jberkus/annotated.conf) is a repository that contains materials for understanding postgresql.conf better, including [this CSV file](https://github.com/jberkus/annotated.conf/blob/master/annotated.csv) explaining _all 269 postgresql.conf settings_. 

Josh Berkus   

[pgBackRest 2.01 Released](https://www.postgresql.org/about/news/1843/) — [pgBackRest](https://pgbackrest.org/) is a Postgres backup and restore system designed to scale up to the largest Postgres databases and workloads. It supports backups to S3, encryption, tablespaces, checksum validation, and more. Version 2 is written in C for performance. 

PostgreSQL Global Development Group   [![\](https://copm.s3.amazonaws.com/f173c44b.jpg)](http://postgresvision.com/) 

[Register Now: Postgres Vision 2018 | Boston, June 5 & 6](http://postgresvision.com/) — Deploying Postgres in the cloud, the rise of DBaaS, the changing role of the DBA, moving Oracle workloads to the cloud, addressing GDPR, and more. The conference agenda is now live. 

Postgres Vision sponsor   

▶[PostgreSQL at 20TB and Beyond: Analytics at a Massive Scale](https://www.youtube.com/watch?v=BgcJnurVFag) — A talk on how Postgres is being used to do near-real-time analytics on 400TB of high velocity data. _30 minutes._ 

Chris Travers   

[Postgres Begins Landing LLVM JIT Support for Faster Performance](https://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-LLVM-JIT-Landing#pgllvm) — _“JIT-compiling expressions for PostgreSQL has been found to be up to ~20%+ faster in database tests like TPC-H.”_ 

Michael Larabel   

[Monitoring Postgres VACUUM Processes](https://www.datadoghq.com/blog/postgresql-vacuum-monitoring/) — A thorough guide to the art and science of investigating and resolving issues with Postgres’s vacuuming processes. This will be of particular interest if your use case involves heavy updating or deletion of data. 

Emily Chang   

[An Easy Recipe for Creating a PostgreSQL Cluster with Docker Swarm](http://info.crunchydata.com/blog/an-easy-recipe-for-creating-a-postgresql-cluster-with-docker-swarm) — How to create a PG primary-replica cluster using Docker Swarm. 

Jason O'Donnell   

[A Guide to Using pgBouncer](https://severalnines.com/blog/guide-using-pgbouncer) — An introduction to [pgBouncer](https://pgbouncer.github.io/), a lightweight connection pooler for Postgres. 

Vladimir Svedov   

[Setting Up the pgbackrest Postgres Backup System](http://www.pgdba.org/post/fun_pgbackrest/) 

Federico Campoli   

[Migrating a Heroku App from MySQL to Postgres using PGLoader](https://medium.com/@sethweinheimer/migrating-a-heroku-app-from-mysql-to-postgres-using-pgloader-ecfddd55173e) 

Seth Weinheimer   

▶[Using Performance Insights to Analyze Performance of Amazon Aurora PostgreSQL](https://www.youtube.com/watch?v=xzVyu1prBvY) — A brief video from AWS on using their _Performance Insights_ system to monitor its Amazon Aurora flavored version of Postgres. 

Amazon Web Services   

[OmniDB - Interactive Browser-Based Tool for Managing PostgreSQL](https://www.2ndquadrant.com/en/resources/omnidb/?utm_source=cp&utm_medium=pgweekly&utm_campaign=cppgweekly) 

2ndQuadrant PostgreSQL Products sponsor   

[Announcing pgDash: Deep-Dive Monitoring for PostgreSQL](https://www.rapidloop.com/blog/announcing-pgdash.html) — A future commercial offering but free during beta. 

RapidLoop         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom