X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F278111F662B for ; Wed, 5 Apr 2006 18:58:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37948-01 for ; Wed, 5 Apr 2006 18:58:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 6146511F6621 for ; Wed, 5 Apr 2006 18:58:47 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 48A4E30F1A; Wed, 5 Apr 2006 23:58:47 +0200 (MET DST) From: August Zajonc X-Newsgroups: pgsql.performance Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3 Date: Wed, 05 Apr 2006 14:58:49 -0700 Organization: Hub.Org Networking Services Lines: 25 Message-ID: References: <7583B3F1891CC0429FA4A44952AA539C66FA6D@wfm-exchprd2.wfm.pvt> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5 (Windows/20051201) In-Reply-To: <7583B3F1891CC0429FA4A44952AA539C66FA6D@wfm-exchprd2.wfm.pvt> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.096 required=5 tests=[AWL=0.096] X-Spam-Score: 0.096 X-Spam-Level: X-Archive-Number: 200604/71 X-Sequence-Number: 18155 Juan Casero (FL FLC) wrote: > When I hit > this pgsql on this laptop with a large query I can see the load spike up > really high on both of my virtual processors. Whatever, pgsql is doing > it looks like both cpu's are being used indepently. Intel HT was partly a marketing thing, you don't really get two CPU's / cores etc. The virtual CPU is really that, there is only one cpu doing the actual work with some extra glue to help the "hyperthreading". As to how hyper intel's hyperthreading is, OSDL did some testing (I think the dbt2 workload) and I remember HT reducing performance for pgsql by about 15%. Worth looking up, benchmarks are subject to a lot of issues but was interesting. There have been some seriously good recommendations in this newsgroup for nice high powered servers, including good disk subsystems. Most involve some AMD Opertons, lots of spindles with a good raid controller preferred to one or two large disks and a good helping of ram. Be interesting to get some numbers on the sunfire machine. - August