TLDR Understanding the new cgroups v2 API by Rami Rosen

Cgroups v2 is a new API designed to make it more suitable for container resource limitation.

TLDR Using cgroups to limit I/O by André Carvalho

Cgroups V1 (and hense docker too) can’t limit non O_DIRECT io, while cgroups v2 can!

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

Postgres got a new DBA…

TLDR Troubleshooting Postgres Streaming Replication by Jonathan Katz

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

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 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 PostgreSQL and SRE : Log Shipping Replication by Nitigya Sharma

Storing important data in one…

TLDR Cgroups v2: resource management done even worse the second time around by davmac

Despite an attempt to create clearer API and simplify controllers implementation, v2 got its own quirks, you should…

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.