From: grant@amadensor.com
To: Scott Carey <scott@richrelevance.com>
Cc: grant@amadensor.com <grant@amadensor.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Fun little performance IMPROVEMENT...
Date: Fri, 21 Jan 2011 14:26:30 -0700 (MST)
Message-ID: <9222245723d86e1dee3a6f424f04974a.squirrel@grant.boldlygoingnowhere.org> (raw)
In-Reply-To: <C95F3502.1B8D9%scott@richrelevance.com>
References: <C95F3502.1B8D9%scott@richrelevance.com>
>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: grant@amadensor.com, scott@richrelevance.com, tgl@sss.pgh.pa.us
Subject: Re: Fun little performance IMPROVEMENT...
In-Reply-To: <9222245723d86e1dee3a6f424f04974a.squirrel@grant.boldlygoingnowhere.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox