Handling Growth With Postgres: 5 Tips From Instagram
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 hasn’t changed.
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)
