Slashdot Mirror

← Back to Stories (view on slashdot.org)

PostgreSQL 8.2 Released

Posted by ryuzaki0 on from the faster-so-they-say dept.

An anonymous reader writes to let us know that PostgreSQL 8.2 has been released (bits, release notes). 8.2 is positioned as a performance release. PostgreSQL it is still missing the SQL:2003 Window Functions that are critical in business reporting, so Oracle and DB2 will still win out for OLAP/data warehouse applications.

4 of 147 comments (clear)

  1. Re:bitmap? by jrockway · · Score: 1, Funny

    Sure would be nice if you sent in a patch.

    --
    My other car is first.
  2. Re:Real Men don't use Window Functions by larry+bagina · · Score: 4, Funny

    According to the MySQL fanbois, Window Functions are bad for performance and not even useful. Just like subselects, data integrity, triggers, and transactions. Oh wait, MySQL 5 supports subselects. Subselects are no longer bad for performance.

    --
    Do you even lift?

    These aren't the 'roids you're looking for.

  3. Re:Performance? by greg1104 · · Score: 5, Funny

    How fast is it against MyISAM?

    I've managed to get my PostgreSQL installation tuned to very high speeds simply by switching the database disk over to /dev/null. It runs fast as hell, and the data integrity is basically the same as MyISAM.

  4. One thing you cant do in PostgreSQL ... by euice · · Score: 2, Funny

    ... is create a smallint index on an int column ;-)