Cybertec PostgreSQL Configurator
Select your version of PostgreSQL:
GB of RAM in your server:
Number of CPUs (= cores):
Number of disks:
How big is your database (in Gb)?
How would you describe your workload?
Mostly simple short transactions (OLTP)
Mostly simple SQL with occasional complicated SQL
Mostly complicated real time SQL queries
Purely analytical and large aggregations
How many percent of your transactions are purely reading?
How many concurrent open connections do you expect?
How many replicas do you need?
Which backup method are you planning to use?
pg_dump: Textual dumps
pg_basebackup: Binary backups
pglogical and alike
Can you lose single transactions in case of a crash?
Are you willing to try out experimental features for better performance?
© Cybertec – The PostgreSQL Database Company