PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

This process is more of a thought experiment. We will present some very rough estimates of I/O performance for many different disk types. We should increment the entries in our hardware spreadsheet based on the perceived need for each.

The main things we will need for this process are numbers. During development, applications commonly have a goal, expected client count, table count, estimated growth rates, and so on. Even if we must guess many of these, each will contribute to our IOPS requirements. Have these numbers ready, even if they're simply guesses.

If the application already exists on a development or stage environment, try to get the development or QA team to run operational tests. This is a great opportunity to gather ...