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
