Greenplum Database 2.3 Available for Public Download

Greenplum Inc. has released Greenplum Database 2.3 (formerly called Bizgres
MPP), the scalable data warehousing clustered version of PostgreSQL. It is
available for trial download at BGN.greenplum.com, the Bizgres Network
website.

Greenplum Database 2.3 is based on PostgreSQL 8.1.5 and will support most
PostgreSQL applications out of the box. It allows you to spread your
database across multiple servers, and run parallelized queries over
databases that are many terabytes in size, with data read rates over
10GB/second. Greenplum Database is built on a fault-tolerant shared-nothing
architecture which allows for cluster expansion, using commodity hardware.

New Features in 2.3 include:

-- Workload Management via role-based resource queues. A resource queue
has attributes that limit the size and/or total number of queries that can
be executed by the users or roles in that queue. By assigning all of your
database roles to the appropriate resource queue, administrators can control
concurrent user queries and prevent the system from being overloaded.

-- A new type of join node called "Adaptive Nestloop" has been added to the
Greenplum Database query planner. An adaptive nestloop causes the executor
to favor a hash-join over a nested-loop join if the number of rows on the
outer side of the join exceeds a precalculated threshold. This parameter
improves performance of index operations, which previously favored slower
nested-loop joins. For certain types of queries, this has improved
performance by 60%.

-- This release introduces administration scripts to facilitate the creation
and maintenance of partitioned tables and their associated rewrite rules.
Table partitioning is a powerful feature that can be used to enhance query
performance. These scripts ease the administrative burden of managing
partitioned tables, making it easier to take advantage of the performance
benefits of table partitioning.

Greenplum Inc. of San Mateo is a sponsor of the PostgreSQL and Bizgres open
source projects. The open source Bizgres Database remains available at
www.bizgres.org. Greenplum Database is Greenplum's commercial offering.

For questions from the community, please contact John Eshleman, jeshleman (
at ) greenplum ( dot ) com (dot ) Members of the press should contact Emily
Swanson, eswanson ( at ) breakawaycom ( dot ) com ( dot )

--
John Eshleman
Greenplum Inc.