From: Luke Lonergan <llonergan@greenplum.com>
To: Juan Casero (FL FLC) <Juan.Casero@wholefoods.com>
To: pgsql-performance@postgresql.org
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Date: Wed, 05 Apr 2006 14:37:28 -0700
Message-ID: <C05986A8.20ECD%llonergan@greenplum.com> (raw)
In-Reply-To: <7583B3F1891CC0429FA4A44952AA539C66FA6D@wfm-exchprd2.wfm.pvt>
Juan,
On 4/5/06 1:54 PM, "Juan Casero (FL FLC)" <Juan.Casero@wholefoods.com>
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
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: llonergan@greenplum.com, Juan.Casero@wholefoods.com
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
In-Reply-To: <C05986A8.20ECD%llonergan@greenplum.com>
* 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