Re: Fun little performance IMPROVEMENT...

From: grant(at)amadensor(dot)com
To: "Scott Carey" <scott(at)richrelevance(dot)com>
Cc: "grant(at)amadensor(dot)com" <grant(at)amadensor(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Fun little performance IMPROVEMENT...
Date: 2011-01-21 21:26:30
Message-ID: 9222245723d86e1dee3a6f424f04974a.squirrel@grant.boldlygoingnowhere.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> My guess is its something hypervisor related. If this happened on direct
> hardware I'd be more surprised. Hypervisors have all sorts of stuff going
> on, like throttling the number of CPU cycles a vm gets. In your idle
> case, your VM might effectively occupy 1Ghz of a CPU, but 2Ghz in the
> loaded case.
>
I will be building a new machine this weekend on bare hardware. It won't
be very big on specs, but this is only 5 million rows, so it should be
fine. I will try it there.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Madhu Ramachandran 2011-01-21 22:10:28 Re: copy command and blobs
Previous Message grant 2011-01-21 21:24:47 Re: Fun little performance IMPROVEMENT...