#272 — September 5, 2018

Read on the Web

Postgres Weekly

Tuning Postgres Database Parameters to Optimize Performance — A look at 8 key settings you can tune in your PG setup, as the out of the box settings are designed to ensure reliability across different workloads but not raw perf.

Ibrar Ahmed

Coming to PG11: Parallel CREATE INDEX for Better Performance — Last week, we covered an update to Postgres that would make column creation quicker, and this week we see how Postgres 11 will be able to create indexes in parallel.

Hans-Jürgen Schönig

Because Your Data Is Your Business — PostgreSQL Experts provides full-stack support for PostgreSQL, including database tuning, emergency support, and remote DBA services, including 24x7 support.

PostgreSQL Experts, Inc. sponsor

Cryptographically Authenticated Rows — A way, though possibly overkill for most scenarios, to detect changed rows though message authentication codes.

Bruce Momjian

How to Monitor Postgres using Nagios — Regardless of what database technology you use, monitoring is essential. Nagios is a widely popular monitoring tool and you can use it to keep track of your Postgres installs too.

Sebastian Insausti

Managing Multiple Postgres Installations with 'pgenv' — pgenv is a shell script to quickly manage multiple PostgreSQL installations on the same host.

Luca Ferrari

Why and How Postgres's Write Ahead Log (WAL) Bloats — A look at some of the most common causes of WAL (Write-Ahead Log) bloat.

Pavel Trukhanov

Migrating a Standalone PostgreSQL Instance to Amazon Aurora

Pavel Tsiukhtsiayeu

What 'hot_standby_feedback' Really Does — How to prevent streaming replication conflicts with hot_standby_feedback and VACUUM.

Cybertec

Watch the Video - Performance Monitoring for PostgreSQL

Severalnines sponsor

What's New in pgwatch2 1.4.0pgwatch2 pgwatch2 is a flexible, self-contained PG metrics monitoring/dashboard solution. 1.4.0 makes it faster and easier to deploy.

Kaarel Moppel

Events

PostgreSQL Day 2018 September 10 (Portland, Oregon) A day of presentations about PostgreSQL.

PostgresConf Silicon Valley October 15-16 (San Jose, CA) The perfect opportunity for all walks of Postgres life to connect, lead and learn all about Postgres and the related ecosystem.

FOSDEM PGDay 2019 February 1, 2019 (Brussels, Belgium) An extension to the regular PostgreSQL activities at FOSDEM.