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 E932611F670F for ; Wed, 5 Apr 2006 20:04:06 -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 40204-02 for ; Wed, 5 Apr 2006 20:04:06 -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 52F7911F6745 for ; Wed, 5 Apr 2006 20:04:04 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 52CFA30DB2; Thu, 6 Apr 2006 01:04:04 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3 Date: Wed, 05 Apr 2006 18:12:43 -0400 Organization: cbbrowne Computing Inc Lines: 19 Message-ID: <60fykrn02s.fsf@dba2.int.libertyrms.com> References: <7583B3F1891CC0429FA4A44952AA539C66FA6D@wfm-exchprd2.wfm.pvt> <200604051501.40109.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:1+gil8K/dDQuoMzAS/1GJ0x/81E= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.306 required=5 tests=[AWL=0.306] X-Spam-Score: 0.306 X-Spam-Level: X-Archive-Number: 200604/77 X-Sequence-Number: 18161 josh@agliodbs.com (Josh Berkus) writes: > Juan, > >> 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. > > Nope, sorry, you're being decieved. Postgres is strictly one process, one > query. It's not entirely deception; there is indeed independent use of both CPUs, it's just that it isn't from multithreading... -- output = reverse("gro.mca" "@" "enworbbc") http://www.ntlug.org/~cbbrowne/internet.html "Don't use C; In my opinion, C is a library programming language not an app programming language." -- Owen Taylor (GTK+ and ORBit developer)