PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

Wow, that's a lot of work! There's a reason for everything, of course.

In the initial three steps, we're trying to determine how many operations might touch an object on disk. For every user that's actively loading a page, for every query in that page, and for every table in that query, that's a potential disk read or write.

We double that number to account for the fact we're estimating these values. It's a common engineering trick to double or triple calculations to absorb unexpected capacity, variance in materials, and so on. We can use that same technique here.

Why did we suggest dividing the user count by 50 to get the connection total? Since we do not know the average query runtime, we assume 20 ms for each query. For ...