People often focus on table bloat in PostgreSQL, but index bloat is not discussed much. Index bloat happens when lots of deletions or updates are performed on an index causing dead tuples.
But wouldn't VACUUM reclaim those dead tuples?
Uber released a new article on the challenges they faced as they scaled CacheFront (integrated cache for their database). Mainly cache staleness and strong consistency.
Also, I like the quote “You can’t improve what you can’t measure.” by Peter Drucker.
uber.com/en-EG/blog/how…
Most vulnerabilities and outages are born from new features. Everyone is racing to build more, break more. Maybe we should stop pushing. Appreciate the internet as it is… before we ruin that too.
