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 277FA11F66D8 for ; Wed, 5 Apr 2006 18:37:35 -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 17234-08 for ; Wed, 5 Apr 2006 18:37:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id B3F8311F66CE for ; Wed, 5 Apr 2006 18:37:32 -0300 (ADT) Received: from 172.16.1.148 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Wed, 05 Apr 2006 17:37:30 -0400 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01HOST02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 5 Apr 2006 17:37:30 -0400 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Wed, 5 Apr 2006 21:37:30 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Wed, 05 Apr 2006 14:37:28 -0700 Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3 From: "Luke Lonergan" To: "Juan Casero (FL FLC)" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3 Thread-Index: AcZY2tjXfVRhB87QTyyEQXkYWR91JAAAagagAAVFz+oAAEdD8AABm2MG In-Reply-To: <7583B3F1891CC0429FA4A44952AA539C66FA6D@wfm-exchprd2.wfm.pvt> MIME-Version: 1.0 X-OriginalArrivalTime: 05 Apr 2006 21:37:30.0238 (UTC) FILETIME=[241959E0:01C658F9] X-WSS-ID: 682AE7100NK2394430-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.345 required=5 tests=[AWL=0.092, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.345 X-Spam-Level: * X-Archive-Number: 200604/65 X-Sequence-Number: 18149 Juan, On 4/5/06 1:54 PM, "Juan Casero (FL FLC)" wrote: > I am not sure about this. I mean I have postgresql 8.1.3 running on my > Windows XP P4 HT laptop that I use for testing my webapps. 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. The usage curve is > not identical on both of them that makes me think that parts of the > server are multithreaded. Admittedly I am not familiar with the source > code fo postgresql so I was hoping maybe one of the developers who is > could definitely answer this question. There's no part of the Postgres backend that is threaded or multi-processed. A reasonable explanation for your windows experience is that your web server or the psql client may be taking some CPU cycles while the backend is processing your query. Also, depending on how the CPU load is reported, if the OS is doing prefetching of I/O, it might show up as load. - Luke