Re: Sun Fire T2000 and PostgreSQL 8.1.3 - Mailing list pgsql-performance

From Chris Browne
Subject Re: Sun Fire T2000 and PostgreSQL 8.1.3
Date
Msg-id 60fykrn02s.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Re: Sun Fire T2000 and PostgreSQL 8.1.3  ("Juan Casero \(FL FLC\)" <Juan.Casero@wholefoods.com>)
List pgsql-performance
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)

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Next
From: Chris Mair
Date:
Subject: Re: bad performance on Solaris 10