From: Luke Lonergan <llonergan@greenplum.com>
To: Juan Casero (FL FLC) <Juan.Casero@wholefoods.com>
To: pgsql-performance@postgresql.org
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Date: Wed, 05 Apr 2006 13:43:29 -0700
Message-ID: <C0597A01.20EAA%llonergan@greenplum.com> (raw)
In-Reply-To: <7583B3F1891CC0429FA4A44952AA539C66FA2C@wfm-exchprd2.wfm.pvt>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: llonergan@greenplum.com, Juan.Casero@wholefoods.com
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
In-Reply-To: <C0597A01.20EAA%llonergan@greenplum.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox