VM DB tests KVM testing on Ubuntu 22.04 via the Phoronix Test Suite. jammy-epyc_rome_ibpd-hv_milan_6.6: Processor: 4 x AMD EPYC (with IBPB) (4 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 1 x 8 GB RAM QEMU, Disk: 107GB QEMU HDD, Graphics: bochs-drmdrmfb, Monitor: QEMU Monitor, Network: Red Hat Virtio device OS: Ubuntu 22.04, Kernel: 5.15.0-88-generic (x86_64), Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768, System Layer: KVM jammy-epyc_rome_ibpb_big-hv_milan_6.6: Processor: 16 x AMD EPYC (with IBPB) (16 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 4 x 16 GB RAM QEMU, Disk: 107GB QEMU HDD, Graphics: bochs-drmdrmfb, Monitor: QEMU Monitor, Network: Red Hat Virtio device OS: Ubuntu 22.04, Kernel: 5.15.0-88-generic (x86_64), Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768, System Layer: KVM jammy-epyc_rome_ibpb_med-hv_milan_6.6: Processor: 8 x AMD EPYC (with IBPB) (8 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 1 x 16 GB RAM QEMU, Disk: 107GB QEMU HDD, Graphics: bochs-drmdrmfb, Monitor: QEMU Monitor, Network: Red Hat Virtio device OS: Ubuntu 22.04, Kernel: 5.15.0-88-generic (x86_64), Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768, System Layer: KVM jammy-epyc_rome_ibpb_big-hv_milan-6.2: Processor: 16 x AMD EPYC (with IBPB) (16 Cores), Motherboard: QEMU Standard PC (i440FX + PIIX 1996) (1.15.0-1 BIOS), Chipset: Intel 440FX 82441FX PMC, Memory: 4 x 16 GB RAM QEMU, Disk: 107GB QEMU HDD, Graphics: bochs-drmdrmfb, Monitor: QEMU Monitor, Network: Red Hat Virtio device OS: Ubuntu 22.04, Kernel: 5.15.0-88-generic (x86_64), Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768, System Layer: KVM MariaDB 11.0.1 Clients: 1 Queries Per Second > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 1032 |================================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 972 |=============================== jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 1033 |================================= jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1025 |================================= MariaDB 11.0.1 Clients: 64 Queries Per Second > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 292 |=============================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 305 |================================ jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 323 |================================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 316 |================================= MariaDB 11.0.1 Clients: 128 Queries Per Second > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 149 |========================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 205 |================================== jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 206 |================================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 194 |================================ MariaDB 11.0.1 Clients: 256 Queries Per Second > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 127 |========================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 173 |================================== jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 164 |================================ jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 171 |================================== MariaDB 11.0.1 Clients: 512 Queries Per Second > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 127 |========================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 170 |================================== jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 152 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 171 |================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Only TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 31388 |======================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 33978 |========================== jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 42606 |================================ jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 36126 |=========================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 0.033 |================================ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 0.030 |============================= jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 0.024 |======================= jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 0.028 |=========================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Write TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 478 |================================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 458 |================================= jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 479 |================================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 472 |================================== PostgreSQL 16 Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 2.094 |=============================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 2.183 |================================ jammy-epyc_rome_ibpb_med-hv_milan_6.6 . 2.090 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 2.120 |=============================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 146543 |========= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 498731 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 515784 |=============================== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 0.341 |================================ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 0.100 |========= jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 0.097 |========= PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 134452 |======== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 511417 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 505483 |=============================== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 0.744 |================================ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 0.196 |======== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 0.198 |========= PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 122839 |=========== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 359764 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 349808 |============================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 2.037 |================================ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 0.695 |=========== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 0.715 |=========== PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 1306 |================================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1173 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1097 |============================ PostgreSQL 16 Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 38.80 |=========================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 43.96 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 46.35 |================================ PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 116754 |========= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 403349 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 377686 |============================= PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 4.283 |================================ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1.240 |========= jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1.325 |========== PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 1316 |================================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1270 |================================ jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1173 |============================= PostgreSQL 16 Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 77.30 |============================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 79.96 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 85.91 |================================ PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 1373 |================================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1327 |================================ jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1278 |=============================== PostgreSQL 16 Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 183.91 |============================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 190.91 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 197.71 |=============================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write TPS > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 1337 |================================= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1206 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1253 |=============================== PostgreSQL 16 Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average Latency ms < Lower Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 380.46 |============================ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 418.55 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 405.08 |============================== RocksDB 8.0 Test: Random Fill Op/s > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 190181 |==================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 301962 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 301084 |=============================== RocksDB 8.0 Test: Random Read Op/s > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 22334662 |======= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 89901681 |============================= jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 90437013 |============================= RocksDB 8.0 Test: Update Random Op/s > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 139914 |================ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 273480 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 272273 |=============================== RocksDB 8.0 Test: Sequential Fill Op/s > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 212628 |==================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 323547 |=============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 313768 |============================== RocksDB 8.0 Test: Random Fill Sync Op/s > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 481 |========== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1581 |================================= jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1496 |=============================== RocksDB 8.0 Test: Read While Writing Op/s > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 355565 |======== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1373704 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1370222 |============================== RocksDB 8.0 Test: Read Random Write Random Op/s > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 422690 |============ jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1076222 |============================== jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1090527 |============================== InfluxDB 1.8.2 Concurrent Streams: 4 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000 val/sec > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 528273.1 |==================== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 766058.9 |============================= jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 769556.0 |============================= InfluxDB 1.8.2 Concurrent Streams: 64 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000 val/sec > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 690751.4 |============== jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1422637.0 |============================ jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1429053.1 |============================ InfluxDB 1.8.2 Concurrent Streams: 1024 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000 val/sec > Higher Is Better jammy-epyc_rome_ibpd-hv_milan_6.6 ..... 34650.4 |= jammy-epyc_rome_ibpb_big-hv_milan_6.6 . 1610766.6 |============================ jammy-epyc_rome_ibpb_big-hv_milan-6.2 . 1604726.1 |============================