As we’ve scaled Instagram to an ever-growing number of active users,
Postgres has continued to be our solid foundation and the canonical
data storage for most of the data created by our users. While less
than a year ago, we blogged about how we “stored a lot of data” at
Instagram at 90 likes per second, we’re now pushing over 10,000
likes per second at peak—and our fundamental storage technology
I only knew about the fifth one and I think the 2 tips about partial and functional indexes being extremely useful in general.
Original title and link: Handling Growth With Postgres: 5 Tips From Instagram ( ©myNoSQL)