n0derunner

    Benchmarking with Postgres PT2

    Published: (Updated: ) in Postgres, , , by .

    In this example we run pgbench with a scale factor of 1000 which equates to a database size of around 15GB. The linux VM has 32G RAM, so we don’t expect to see many reads. Using prometheus with the Linux node exporter we can see the disk IO pattern from pgbench. As expected the write […]

    Benchmarking with Postgres PT1

    Published: (Updated: ) in Postgres, , , by .

    In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine.  Assume a Linux virtual machine that has Postgres installed. Specifically using a Bitnami virtual appliance. Once the VM has been started, connect to the console Allow access to postgres port 5432 – which is the postgres […]

    HCI Performance testing made easy (Part 3)

    Published: (Updated: ) in X-Ray, , , , , , by .

    Creating a HCI benchmark to simulate multi-tennent workloads     HCI deployments are typically multi-tennant and often different nodes will support different types of workloads. It is very common to have large resource-hungry databases separated across nodes using anti-affinity rules.  As with traditional storage, applications are writing to a shared storage environment which is necessary to […]