Postgres config benchmarking KVM testing on CentOS Linux 7 via the Phoronix Test Suite. pgtune: Processor: Common KVM @ 2.20GHz (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 8196 MB RAM QEMU, Disk: 21GB QEMU HDD, Graphics: bochsdrmfb OS: CentOS Linux 7, Kernel: 3.10.0-862.14.4.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM pgconfigurator: Processor: Common KVM @ 2.20GHz (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (rel-1.11.0-0-g63451fca13-prebuilt.qemu-project.org BIOS), Memory: 1 x 8196 MB RAM QEMU, Disk: 21GB QEMU HDD, Graphics: bochsdrmfb OS: CentOS Linux 7, Kernel: 3.10.0-862.14.4.el7.x86_64 (x86_64), Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 1024x768, System Layer: KVM PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Only TPS > Higher Is Better pgtune ......... 84600 |======================================================= pgconfigurator . 82758 |====================================================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Normal Load - Mode: Read Write TPS > Higher Is Better pgtune ......... 1472 |======================================================== pgconfigurator . 1474 |======================================================== PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Only TPS > Higher Is Better pgtune ......... 8047 |================================================= pgconfigurator . 9106 |======================================================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only TPS > Higher Is Better pgtune ......... 82812 |======================================================= pgconfigurator . 82393 |======================================================= PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Single Thread - Mode: Read Write TPS > Higher Is Better pgtune ......... 168 |======================================================== pgconfigurator . 171 |========================================================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Only TPS > Higher Is Better pgtune ......... 64134 |======================================================= pgconfigurator . 63870 |======================================================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write TPS > Higher Is Better pgtune ......... 3209 |======================================================== pgconfigurator . 3227 |======================================================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write TPS > Higher Is Better pgtune ......... 5884 |======================================================== pgconfigurator . 5579 |===================================================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only TPS > Higher Is Better pgtune ......... 8414 |======================================================== pgconfigurator . 8209 |======================================================= PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better pgtune ......... 90143 |======================================================= pgconfigurator . 89786 |======================================================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only TPS > Higher Is Better pgtune ......... 7248 |======================================================== pgconfigurator . 7065 |======================================================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write TPS > Higher Is Better pgtune ......... 307 |========================================================= pgconfigurator . 305 |========================================================= PostgreSQL pgbench 10.3 Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better pgtune ......... 1514 |======================================================== pgconfigurator . 1500 |======================================================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write TPS > Higher Is Better pgtune ......... 490 |======================================================== pgconfigurator . 498 |========================================================= PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better pgtune ......... 90913 |======================================================= pgconfigurator . 89735 |====================================================== PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only TPS > Higher Is Better pgtune ......... 69025 |======================================================= pgconfigurator . 68256 |====================================================== PostgreSQL pgbench 10.3 Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better pgtune ......... 3128 |======================================================== pgconfigurator . 3076 |======================================================= PostgreSQL pgbench 10.3 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write TPS > Higher Is Better pgtune ......... 6913 |======================================================== pgconfigurator . 6455 |====================================================