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 14:54:13 -0700
Message-ID: <C0598A95.20ED9%llonergan@greenplum.com> (raw)
In-Reply-To: <7583B3F1891CC0429FA4A44952AA539C66FA77@wfm-exchprd2.wfm.pvt>
Juan,
On 4/5/06 2:45 PM, "Juan Casero (FL FLC)" <Juan.Casero@wholefoods.com>
wrote:
> Do you think bizgres might be a good choice of database server for the
> Ultrasparc T1 based T2000? I have downloaded the source code but I was
> hoping to find out if the potential performance gains were worth the
> effort to compile and install the code.
Bizgres (non-MPP) does not do any multi-CPU parallelism, so it won't use
more CPUs in your T2000. It does have the faster sort performance and an
on-disk bitmap index, both of which will make it run many times (3-6) faster
than 8.1 Postgres depending if your queries use larger data or involve
sorts.
Bizgres MPP is closed source and unfortunately for your T2000 experiment it
doesn't currently support Solaris SPARC CPUs, only Solaris x86. It would
use all of your CPUs and I/O channels on one or more machines for every
query. Again, it's optimized for queries where that use a lot of data or
have a lot of complexity (sorts, aggregations, joins, 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: <C0598A95.20ED9%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