Database Administration

TLDR How Twitch uses PostgreSQL by Aaron Brashears

Real life with over 100 PG clusters in different regions.

Topology

As for Oct, 2016 Twitch

• has ~125 OLTP database hosts…

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 Finding surprising patterns in a time series database in linear time and space by Keogh et al. thru A Colyer

If you want to detect holidays by looking on some power demand time series — there’s a…