DevOps

TLDR Decrypting PgBouncer’s Diagnostic Information by Ivan Vergiliev

Why high # of active connections is not a problem, and what to do with waiting client's connections.

TLDR Connection initiation overhead is killing your webapp — by Eric Worden

What is the proper max_connections for PostgreSQL? — is the wrong question! Use a connection pool, like PgBouncer.

TLDR PostgreSQL and SRE : Log Shipping Replication by Nitigya Sharma

Storing important data in one…

TLDR Postgres feature highlight — Wait events in 9.6 and 10 by Michael Paquier

Postgres got a new DBA…

TLDR Troubleshooting Daily Write Spikes on PostgreSQL RDS by E. Tunggawan

Proactive investigation of a spike anomaly in DB metrics lead to discovery of huge temp file writes and one crazy Pg quirk.

TLDR Troubleshooting Postgres Streaming Replication by Jonathan Katz

Be prepared — use WAL archiving, replication slots, and ensure you’re are constantly monitoring.

TLDR Migrating a 130TB Cluster from Elasticsearch 2 to 5 in 20 Hours with 0 Downtime by Fred de Villamil

Replicate it using built-in ES capabilities, then reindex delta from your main data source. Also —…

Super short TLDR: Metrics, tracing, and logging in one picture by Peter Bourgon

Metrics, tracing, and logging can definitely overlap and here’s how: