From: Chris Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Date: Wed, 05 Apr 2006 18:11:54 -0400
Message-ID: <60k6a3n045.fsf@dba2.int.libertyrms.com> (raw)
References: <7583B3F1891CC0429FA4A44952AA539C66FA6D@wfm-exchprd2.wfm.pvt>
Juan.Casero@wholefoods.com ("Juan Casero \(FL FLC\)") writes:
> 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.
This is almost certainly a function of the fact that you're running
the single-threaded backend process, which then feeds a
single-threaded front end process, namely the application that is
being fed data.
For a query that returns a large return set, that will indeed make
both processors get pretty busy; one for the DB server, one for
whatever program is processing the results.
--
select 'cbbrowne' || '@' || 'acm.org';
http://www.ntlug.org/~cbbrowne/rdbms.html
It's hard to tell if someone is inconspicuous.
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: cbbrowne@acm.org
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
In-Reply-To: <60k6a3n045.fsf@dba2.int.libertyrms.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