---
title: "#231: Monitoring Your Bloat in Postgres"
publication: "Postgres Weekly"
issue: 231
published_at: "2017-11-01"
canonical_url: "https://postgresweekly.com/issues/231"
---

Postgres Weekly 231   . 

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

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

[Amazon Aurora Now with PostgreSQL Compatibility](https://aws.amazon.com/blogs/aws/now-available-amazon-aurora-with-postgresql-compatibility/)Postgres compatibility has been added to AWS Aurora, a performance-oriented relational database, helping you grow beyond the 6TB limit of RDS. Amazon Web Services#news [Monitoring Your Bloat in Postgres](https://www.citusdata.com/blog/2017/10/20/monitoring-your-bloat-in-postgres/)Under the covers, Postgres is, in simplified terms, a giant append only log but to keep things efficient it needs to ‘vacuum’. Here’s how to track the bloat that piles up. Craig Kerstiens [2Q PGConf 2017 - Learn, Connect & Experience the PostgreSQL Ecosystem](http://www.2qpgconf.com)Join us in NYC & Chicago to learn more about recent achievements and exciting future developments in PostgreSQL from the pros. Additionally, on Nov 6 in NYC you can participate in hands on training in: PostgreSQL Security, Postgres-XL, and Postgres-BDR. 2ndQuadrant PostgreSQL Events#sponsored[![\](https://copm.s3.amazonaws.com/5f064be2.jpg)](http://www.2qpgconf.com) [An Intro to Logical Replication in Postgres 10](https://blog.2ndquadrant.com/logical-replication-postgresql-10/)Logical replication is one of the more exciting advancements in Postgres 10. This primer is from a few months ago but is now more relevant than ever. Petr Jelinek [PGConf 2018: Call for Papers Now Open](https://www.linkedin.com/pulse/pgconf-2018-call-papers-now-open-joshua-drake/)PGConf 2018 is happening again in NY and the CFP is open now. If you’ve got something to say about Postgres consider submitting. Joshua Drake#news [Handling Contention with PostgreSQL](https://medium.com/learning-with-diagrams/learning-w-diagrams-handling-contention-with-postgresql-109798b8ad54)Understanding how concurrency is achieved under the hood is pretty important for anyone using databases. Diana Hsieh [Distributed Locking and Error Tracking for Python with Postgres](https://medium.com/@darinmcgill/distributed-locking-and-error-tracking-for-python-with-postgres-9ecc7b916a63) Darin McGill [Four PostgreSQL Tips](http://jakeyesbeck.com/2016/02/21/four-postgresql-tips/)A golden oldie packed with four useful tips that could come in handy the next time you’re running a query. Jake Yesbeck [What It Means to Be A Postgres Extension](https://www.citusdata.com/blog/2017/10/25/what-it-means-to-be-a-postgresql-extension/)Citus Data open sourced their distributed database and “unforked it” from PostgreSQL by refactoring into a PostgreSQL extension. Here’s a recap of that journey. Jason Petersen [Using Arrays for Many-to-Many Relationships in Postgres](https://medium.com/@leshchuk/mtm-on-arrays-in-postgresql-a97f3c50b8c6)..instead of a junction table. Intriguing results. AlekseyL#opinion [Let's Build Better Graphic Tools for Postgres](http://blog.taadeem.net///english/2017/10/30/lets_build_better_graphic_tools_for_postgresql)The challenges ahead for improving Postgres graphical/visual tools. Damien Clochard#opinion [Optimize Database Performance on Amazon RDS for PostgreSQL](https://www.enterprisedb.com/general-inquiry-form)Schedule an EnterpriseDB Tune-Up Service. Ensure proper configuration, optimized for cost and performance. EnterpriseDB#sponsored [PgDriveBackup: Encrypted Postgres Backups for Google Drive](https://github.com/kirillshevch/pg_drive_backup)A simple, Ruby-based solution to make ccrypt-encrypted backups for storage via the Google Drive API. Kirill Shevchenko#tools    

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