Running postgres and reducing I/O overhead

[zBrain]

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?

 

[denos]

Have you considered running it in a container (LXC) instead of KVM? That would give you bare metal performance.

 

[alexskysilk]

https://blog.2ndquadrant.com/pg-phriday-postgres-zfs/