Running postgres and reducing I/O overhead


Active Member
Apr 27, 2013
I'm wondering what the best way to virtualize database (specifically postgres) loads is. The use case in question requires as few I/O bottlenecks as possible. I'm using local ZFS storage on the host and understand if I tune it to 8k records as well as setting Postgres to 8k records you can achieve high performance on bare metal.

I'm not sure how the VM storage is affected though. Should I use ZFS in the guest as well? Can I safely direct mount a zvol from the underlying bare metal?
Have you considered running it in a container (LXC) instead of KVM? That would give you bare metal performance.


The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!