Hello. In out work we are using FreeBSD + Postgres as database server.
We bought a new server based on the C602-A PCH chipset and decided to use Proxmox. I installed Proxmox 3.2, created new VM with FreeBSD 9.2. I installed Postgres 9.3.1 and restored dump of our database. I wrote big SQL-query to analyse performance of the VM. Average result was 120 msec (without Proxmox result – 5 msec). I made another VM with FreeBSD 8.4 and same Postgres. Average result is 50-55 msec.
I tried to use Virtio drivers, but result didn't change.
Please tell me, is it normal that performance so poor? Can i improve performance of VM with FreeBSD.
In all cases i used default postgres.conf. All VM had max CPU and memory.
We bought a new server based on the C602-A PCH chipset and decided to use Proxmox. I installed Proxmox 3.2, created new VM with FreeBSD 9.2. I installed Postgres 9.3.1 and restored dump of our database. I wrote big SQL-query to analyse performance of the VM. Average result was 120 msec (without Proxmox result – 5 msec). I made another VM with FreeBSD 8.4 and same Postgres. Average result is 50-55 msec.
I tried to use Virtio drivers, but result didn't change.
Please tell me, is it normal that performance so poor? Can i improve performance of VM with FreeBSD.
In all cases i used default postgres.conf. All VM had max CPU and memory.