There are decades of accumulated knowledge in optimizing relational databases like PostgreSQL, and so much of it is either unhelpful or downright counterproductive in modern, resource-contentious, cloud-based environments. Disks aren’t disks any more, RAM might not be RAM, and latency has become more than intermittent.
We’ll discuss why and how the cloud is different from traditional hardware, and how that impacts existing optimization strategies. We’ll formulate new strategies for the new environments. And we’ll test those strategies on PostgreSQL on actual cloud instances (including EC2).
[youtube 6_6Vjc8ddMo]
Event: Postgres Open Conference