Performance issue with virtualized DB

From: Antonio Carlos Salzvedel Furtado Junior <acsfj08(at)inf(dot)ufpr(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: Performance issue with virtualized DB
Date: 2012-08-07 22:05:51
Message-ID: CAERqmVrbwek4eXSndwFGajJxuTrRQr+UDQ5BsmdxMzssEtdkVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello PostgreSQL users,

I'm running PostgreSQL 9 in a VM, sing KVM as hypervisor. The whole
database is loaded in a RAM file system.
As other hypervisors, there are some parameters to limit CPU that are
very important to me. I usually need to change the values of these
parameters.

However I'm having a bit of unexpected performance problems. Shouldn't
the query execution times vary linearly with the allocated CPU?
I ran some tests, and I found out that the costs vary "kind of"
linearly until some point. However if I give my VM less than about 20%
of the available CPU, the costs "explode".
The problem is that I need to run multiple VMs on the same host, and I
can't afford that much deterioration. I never heard about a "safe
limit" for CPU allocation. I always thought that CPU would affect the
query linearly.

Regards,

Antonio Carlos Furtado

Browse pgsql-novice by date

  From Date Subject
Next Message Sergey Kirillov 2012-08-09 06:44:34 huge difference in TPS depending of synchornous_commit setting
Previous Message Kevin Grittner 2012-08-06 16:08:36 Re: To get a Table or View like a Calendar with dates