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@xxxxxxxxxxxxx] Sent: Wednesday, April 05, 2006 4:43 PM To: Juan Casero (FL FLC); pgsql-performance@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx> 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
