PostgreSQL

• PostgreSQL indexing: Index scan vs. Bitmap scan vs. Sequential scan (basics).
• Bitmap Index Scan.
• Speeding up SQL queries by orders of magnitude using UNION.
• How the PostgreSQL query optimizer works.
• Your Guide to Connection Management in Postgres.
• BRIN indexes:
  • PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage.
  • BRIN Index for PostgreSQL: Don’t Forget the Benefits.
  • Avoiding the Pitfalls of BRIN Indexes in Postgres.

React

• useReducer instead of useState while calling APIs!.

AWS

• Key considerations in moving to Graviton2 for Amazon RDS and Amazon Aurora databases.

Misc

• Don’t promise, just ship.
• GitLab OKRs.
• The Era of Symbol Fonts.
• Profiling site speed with the Chrome DevTools Performance tab.

Podcast episodes

• Adventures in DevOps: Getting Amazing Personal Productivity with Mason McLead - DevOps 066.
• Making data simple: [Part 1] Al and Cactus Raazi discuss pricing and pricing methods.
• Downtime: Gitlab’s 2017 Postgres Outage.
• Downtime: Auth0 Silently Loses Some Indexes.
• Programar es una mierda: Episodio 79 - El camino del management.