Re: Sun Fire T2000 and PostgreSQL 8.1.3

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Date: 2006-04-05 22:12:43
Message-ID: 60fykrn02s.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

josh(at)agliodbs(dot)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)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-05 22:24:47 Re: Sun Fire T2000 and PostgreSQL 8.1.3
Previous Message Chris Browne 2006-04-05 22:11:54 Re: Sun Fire T2000 and PostgreSQL 8.1.3