Homepage
Open in app
some-tech-tldrs
Sign in
Get started
Tagged in
Postgresql
some-tech-tldrs
Brief summaries of some long, tech related articles. To get the essence in 1 minute.
More information
Followers
33
More, on Medium
Postgresql
pavel trukhanov
in
some-tech-tldrs
Aug 20, 2018
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…
Read more…
3
pavel trukhanov
in
some-tech-tldrs
Aug 15, 2018
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.
Read more…
5
2 responses
pavel trukhanov
in
some-tech-tldrs
Aug 15, 2018
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.
Read more…
pavel trukhanov
in
some-tech-tldrs
Aug 10, 2018
TLDR PostgreSQL and SRE : Log Shipping Replication
by Nitigya Sharma
Storing important data in one…
Read more…
pavel trukhanov
in
some-tech-tldrs
Aug 9, 2018
TLDR Postgres feature highlight — Wait events in 9.6 and 10
by Michael Paquier
Postgres got a new DBA…
Read more…
5
pavel trukhanov
in
some-tech-tldrs
Aug 9, 2018
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.
Read more…
1
pavel trukhanov
in
some-tech-tldrs
Aug 8, 2018
TLDR Troubleshooting Postgres Streaming Replication
by Jonathan Katz
Be prepared — use WAL
archiving,
replication slots
, and
ensure you’re are constantly monitoring.
Read more…
7