#272 — September 5, 2018 |
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 Cybertec |
Watch the Video - Performance Monitoring for PostgreSQL Severalnines sponsor |
What's New in pgwatch2 1.4.0 — pgwatch2 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. |