At The Heart Of A Giant: Postgres At TripAdvisor

2 core-site datacenters with Postgres infrastructure tested to be capable of handling well over 1,100,000 database queries per minute.

Servers with 768GB of RAM so everything fits in memory.

Multi terabyte databases where only 5% can fit in RAM.

A sharded core site (not warehouse!) table with over 2,600,000,000 tuples

This talk will be a look at how Postgres can form the backbone of a site at the scale of 315 million unique visitors a month