---
title: "#234: Visualizing and Tuning Postgres's 'Autovacuum'"
publication: "Postgres Weekly"
issue: 234
published_at: "2017-11-29"
canonical_url: "https://postgresweekly.com/issues/234"
---

Postgres Weekly 234   . 

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

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

[Visualizing and Tuning Postgres's 'Autovacuum'](https://pganalyze.com/blog/visualizing-and-tuning-postgres-autovacuum.html)A look at an approach to autovacuum tuning based on sampling statistics over time, visualizing them, and then making tuning decisions based on data. Lukas Fittl [Transaction Isolation Levels in Postgres](http://shiroyasha.io/transaction-isolation-levels-in-postgresql.html)A look at the four isolation levels for transactions in the SQL standard and how they apply to Postgres. Igor Šarčević [A Single Config Change Improved Slow Query Performance by 50x](https://amplitude.engineering/how-a-single-postgresql-config-change-improved-slow-query-performance-by-50x-85593b8991b0)A look at how a team worked around Postgres picking a particularly inefficient approach to answering a query. Pavan Patibandla [Trust Your PostgreSQL Database with World Renowned Experts at 2ndQuadrant](https://2ndquadrant.com/en/services/rdba/)Remote DBA from 2ndQuadrant experts eliminates the hassle of monitoring and managing your database, ensuring it’s always performing its best & preempting issues that could cause downtime. Remote monitoring allows us to act fast, saving you money & reducing the impact of failure. 2ndQuadrant PostgreSQL Services#sponsored[![\](https://copm.s3.amazonaws.com/698b683a.jpg)](https://2ndquadrant.com/en/services/rdba/) [How Citus Executes Distributed Transactions on Postgres](https://www.citusdata.com/blog/2017/11/22/how-citus-executes-distributed-transactions/)In the new Citus 7.1, an extension for horizontally scaling Postgres, support for distributed transactions has been added, and this is a look at how they pulled it off. citusdata#news [How We Migrated from Heroku PostgreSQL to AWS RDS](https://www.wootric.com/blog/how-we-migrated-from-heroku-postgresql-to-aws-rds/)A practical look at how a customer survey company moved their main production database from Heroku to Amazon Web Services. Wootric [repmgr 4.0 Released: Replication Management for Postgres](https://www.postgresql.org/about/news/1802/)A complete rewrite of the existing codebase that adds full support for Postgres 10 and makes repmgr a fully-fledged extension. 2ndQuadrant#tools [Scaling PG with Read Replicas & Using WAL to Counter Stale Reads](https://brandur.org/postgres-reads)Scaling out operation with read replicas and avoiding the downside of stale reads by observing replication progress. Brandur Leach [Securing Database Traffic with PgBouncer and Amazon RDS](https://medium.com/@ankane/securing-database-traffic-with-pgbouncer-and-amazon-rds-c775b10bad75) Andrew Kane [Get Unlimited Access to Postgres Online Training Content for a Year](https://www.enterprisedb.com/training/subscriptions-credits)EDB Postgres Training e-Subscriptions simplify how you purchase and consume training. Get unlimited access. EnterpriseDB#sponsored [PostgreSQL Configuration for Humans](https://speakerdeck.com/ongres/postgresql-configuration-for-humans)Slides covering the perf advantages of appropriately tuning your postgresql.conf file. Álvaro Hernandez Tortosa [AgensGraph: A Transactional Graph DB Based on Postgres](https://github.com/bitnine-oss/agensgraph) bitnine#code    

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