pgFoundry Project: Bizgres - News

Bizgres 0.9 Bundled

aglio@users.pgfoundry.org (Josh Berkus) — Mon, 03 Apr 2006 16:18:02 GMT

Bizgres 0.9 is now available from the Downloads section of the Bizgres web site: http://www.bizgres.org/downloads.php

The new source package includes the following improvements:
Merged with PostgreSQL 8.1.3 source code for full v8.1 compatibility (Chuck McDevitt)
Bitmap-on-disk indexes, reducing index size for some large tables up to 95% (Jie Zhang, Mark Kirkwood)
Faster external sorts, speeding up queries on large data sets by up to 100% (Simon Riggs, Ayush Parashar, Tom Lane)
Numerous improvements and bug fixes to KETL engine (Nick Wakefield)

Please install and test. We look forward to your feedback!

Bizgres 0.7 Released

aglio@users.pgfoundry.org (Josh Berkus) — Fri, 05 Aug 2005 00:34:41 GMT

Bizgres 0.7 is now available at http://www.bizgres.org. This release of Bizgres begins to fulfill the mission of the Bizgres project by providing a PostgreSQL 8.0 distribution tailored to the needs of data warehousing users.

First, two performance enhancements have been "backported" to the Bizgres code base, which is based on PostgreSQL 8.0.3. Simon Riggs' constraint exclusion patch is included allow users to make much greater use of table partitioning. Tom Lane's bitmapscan, which allows combining indexes in memory and faster index access in some cases, has also been incorporated.

Second, Bizgres is becoming a distribution of tools for Open Source business intelligence. Version 0.7 downloads with the KETL extract, transform and load tool (ETL) from Kinetic Networks, and JasperReports from JasperSoft. To help people make use of these tools for a unified platform, a demo application for analysis of weblog data is provided.

Source tarballs are available here:
http://www.bizgres.org/pages/?pg=downloads
And binary packages for a variety of platforms are available from the Greenplum website, including a multi-platform installer from InstallAnywhere:
http://www.greenplum.com/prod_download.html

Please note that some components of the package are under the LGPL instead of BSD-licensed.

Bizgres 0.6 beta releases

aglio@users.pgfoundry.org (Josh Berkus) — Fri, 08 Jul 2005 21:55:48 GMT

Bizgres beta version 0.6 has been released. Source is available on the
bizgres home page (http://bizgres.org); binaries
for Linux and Solaris are available from GreenPlum
(http://www.greenplum.com/prod_download.html, as "DeepGreen PostgreSQL":
it's the same thing as Bizgres).

This version includes the first patches which Bizgres is getting before
mainstream PostgreSQL. These first two patches are Alon Goldshuv's batch
processing improvement for COPY, which improves bulk loading by as much as
35%. The second is Simon Riggs' patch allowing disabling of WAL logging
on "holding tables", as are frequently used for ETL. Combined, the two
patches can halve disk I/O costs for ETL operations. Both of these
patches have been submitted to PostgreSQL and should be in PostgreSQL 8.1
or 8.2 (if accepted).

Bizgres is based on PostgreSQL 8.0.2, and includes JDBC, an enhanced
Java-based bulk loader, a Windows cross-compile, and a unified installer.
Bizgres is BSD-licensed. Documentation for this version will is avaible on
the Bizgres documentation page
(http://www.bizgres.org/pages.php?pg=documentation).

Bizgres version 0.7, which will include several more significant features
(such as table partitioning and a performance configuration tool) should
be out around July 31. In the meantime, please download, test, and give
us your feedback!