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.