Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0B6811337B4A for ; Fri, 21 Jan 2011 17:30:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 08099-04 for ; Fri, 21 Jan 2011 21:30:16 +0000 (UTC) Received: from amadensor.com (amadensor.com [200.46.208.228]) by mail.postgresql.org (Postfix) with ESMTP id DE7621336FA7 for ; Fri, 21 Jan 2011 17:30:15 -0400 (AST) Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by amadensor.com (Postfix) with ESMTP id ADDCA18A54EF for ; Fri, 21 Jan 2011 21:30:15 +0000 (UTC) Received: from amadensor.com ([200.46.208.228]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 69411-05; Fri, 21 Jan 2011 21:30:08 +0000 (UTC) Received: from dbms (unknown [76.76.81.70]) by amadensor.com (Postfix) with ESMTPA id 4AC9A18A4571; Fri, 21 Jan 2011 21:30:07 +0000 (UTC) Received: from dbms ([127.0.0.1] helo=grant.boldlygoingnowhere.org ident=www-data) by dbms with esmtp (Exim 4.69) (envelope-from ) id 1PgOV3-0004aq-NN; Fri, 21 Jan 2011 14:26:30 -0700 Received: from 159.238.13.4 (SquirrelMail authenticated user grant) by grant.boldlygoingnowhere.org with HTTP; Fri, 21 Jan 2011 14:26:30 -0700 (MST) Message-ID: <9222245723d86e1dee3a6f424f04974a.squirrel@grant.boldlygoingnowhere.org> In-Reply-To: References: Date: Fri, 21 Jan 2011 14:26:30 -0700 (MST) Subject: Re: Fun little performance IMPROVEMENT... From: grant@amadensor.com To: "Scott Carey" Cc: "grant@amadensor.com" , "Tom Lane" , "pgsql-performance@postgresql.org" User-Agent: SquirrelMail/1.4.15 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/211 X-Sequence-Number: 41998 > > 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.