n0derunner

    Notes on tuning postgres for cpu and memory benchmarking

    Published: (Updated: ) in Postgres, Database Performance, , , , , by gary. Leave a Comment on Notes on tuning postgres for cpu and memory benchmarking.

    Recently I wanted to measure the impact of NUMA placement and Hugepages on the performance of postgres running in a VM on a Nutanix node. To do this I needed to drive postgres to do real transactions but have very little jitter/noise from the filesystem and storage. After reading a lot of blogs I came […]

    Performance gains for postgres on Linux with hugepages

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

    For this experiment I am using Postgres v11 on Linux 3.10 kernel. The goal was to see what gains can be made from using hugepages. I use the “built in” benchmark pgbench to run a simple set of queries. Since I am interested in only the gains from hugepages I chose to use the “-S” […]