PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

We need to figure out how many operations per second we can expect. We can estimate this by using the following steps:

1. Collect the number of simultaneous database connections. Start with the expected user count, and divide by 50.
2. Obtain the average number of queries per page. If this is unavailable, use 10.
3. Count the number of tables used in those queries. If this is unavailable, use 3.
4. Multiply these numbers together, and double the result.
5. Multiply the previous total by 8.
6. Increment the Count column in our hardware spreadsheet for one or more of the following, and round up:

• For 3.5" hard drives, divide by 200.
• For 2.5" hard drives, divide by 150.
• For SSD hard drives, divide by 50,000, and then add two.

7. Add 10% to any ...