Estimates: A test with pgbench (scaling factor 1000, 20 connections, duration 300 seconds, not showing detailed logs) and a single small instance (2 cores, 3 GB RAM, 20 GB HDD) resulted in around 830 transactions per second (read and write mixed) and 1100 transactions per second (read only). For a larger instance (4 cores, 8 GB RAM, 600GB Premium SSD) the results were around 3400 (read and write) and 19000 (read only) transactions per second. The database was initialized using
pgbench -i -s 1000 -h <ip> -U <username> <dbname>. For benchmarking the command line used was
pgbench -c 20 -T 300 -h <ip> -U <username> <dbname> for the read/write tests, and
pgbench -c 20 -T 300 -S -h <ip> -U <username> <dbname> for the read only tests.