Slashdot Mirror

← Back to Stories (view on slashdot.org)

PostgreSQL 8.4 Out

Posted by timothy on from the would-you-name-your-daughter-postgres? dept.

TheFuzzy writes "PostgreSQL version 8.4 is now out and available for download. The main cool features in this version are: recursive queries (for doing trees etc.), windowing functions (for doing reports) column-level permissions, parallel database restore, a beta in-place upgrade tool, and a host of administrative improvements. And, of course, better performance, mainly on reporting queries. Some of the over 200 new or enhanced features are listed here."

3 of 191 comments (clear)

  1. Re:So why by ducomputergeek · · Score: 5, Interesting

    No, but Oracle taking over MySQL and the community already showing signs of forking in 4 different directions might be a reason to seriously look at PostgreSQL.

    --
    "The problem with socialism is eventually you run out of other people's money" - Thatcher.
  2. Re:So why by Anonymous Coward · · Score: 5, Informative

    No, the replication and hot standby patches were not considered of high enough quality to be a part of 8.4. They will be a high priority during development of 8.5.

    PostgreSQL would never, ever ship something which has a WTF-list as long as MySQL's replication does: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html

  3. Re:cross database joins?? by Anonymous Coward · · Score: 5, Informative

    If you're coming from MySQL: What MySQL calls "databases" are called "schemas" in PostgreSQL. MySQL has no equivalent of PostgreSQL's "database".

    There is also db-link and dbi-link.