Slashdot Mirror

← Back to Stories (view on slashdot.org)

PostgreSQL 8.1 Available

Posted by ryuzaki0 on from the query-bucket dept.

atani writes "PostgreSQL 8.1 has been posted, though not officially announced as of this moment. This release includes two-phased commits, improved SMP and overall performance, a new role system replaces the older user/group, autovacuum is now within the backend rather than a separate contrib module, and various improvements, performance enhancements, and bugfixes. " You can also read the developer notes for the popular database. One thing is clear- with the newest Postresql and MySql, you have much to choose from.

3 of 261 comments (clear)

  1. Congratulations to the PostgreSQL Team! by mw · · Score: 5, Informative

    I've tested RC1 with some applications, and was really impressed by the bitmap-indices. I hope to see soon a multi-master replication now that 2PC is available. I've heard Slony-2 will have it.

  2. Not announced by Anonymous Coward · · Score: 5, Funny
    PostgreSQL 8.1 has been posted, though not officially announced as of this moment.

    They were probably waiting for their mirrors to finish syncing before some yo-yo posted to /. and caused every other yo-yo to start downloading.

  3. Re:at last "SELECT ... FOR UPDATE NOWAIT" by Daniel_Staal · · Score: 5, Informative

    Most handle it by giving you the view of the data before the other user started to modify it. The person who is editing's edits do not show until all of the edit is finished.

    Postgres docs actually have a chapter on this: Concurrency Control. Like most high-end databases Postgres can handle this situation in different ways, depending on how it is set up...

    A database should never tell you that the data is not avalible. It should always give you the best version of the data it has.

    --
    'Sensible' is a curse word.