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.
Thanks,
Juan
-----Original Message-----
From: Luke Lonergan [mailto:llonergan@greenplum.com]
Sent: Wednesday, April 05, 2006 4:43 PM
To: Juan Casero (FL FLC); pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3
Juan,
On 4/5/06 11:12 AM, "Juan Casero (FL FLC)" <Juan.Casero@wholefoods.com>
wrote:
> I know the postgresql server is not smp aware but I believe parts of
> it are. In particular the buffer manager is supposed to scale the
> performance almost linearly with the number of cpu's (including
virtual ones).
> I don't know however, if I need to recompile the postgresql server
> myself to get those benefits.
As Tom said, to get the benefits of parallelism on one query, you would
need a parallelizing database like Teradata, Oracle Parallel Query
option, Netezza, or Bizgres MPP.
The announcement about Postgres linear scalability for SMP is only
relevant to statement throughput for highly concurrent environments (web
sites, OLTP, etc).
- Luke