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. ---------------------------(end of broadcast)--------------------------- -To unsubscribe from this list, send an email to: [EMAIL PROTECTED]