Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Forum Statistics

Users
Members:
1879
Members Online:
1
Guests Online:
39

Total Post History
Posts:
81448
Topics:
18714

7-Day Post History
New Posts:
0
New Topics:
0
Active Topics:
0

Our newest member
mwojcik

Other

FAQ
All times are UTC [ DST ]

Google Ads

PostgreSQL 8.4 Beta Released

Topics discussing news and products relating to the data management industry
Forum rules
This forum is reserved for industry news from vendors or other interested parties. If you would like to submit an article for this forum, please contact us for further details.
Inclusion of an article does not imply that anyone here has tested the product nor does it imply that we recommend it.
Please wait...

PostgreSQL 8.4 Beta Released

Postby SQLDenis on Wed Apr 15, 2009 8:24 pm

After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards. The major areas of enhancement are:

    Windowing Functions

    Common Table Expressions and Recursive Joins

    Default and variadic parameters for functions

    Parallel Restore

    Column Permissions

    Per-database locale settings

    Improved hash indexes

    Improved join performance for EXISTS and NOT EXISTS queries

    Easier-to-use Warm Standby

    Automatic sizing of the Free Space Map

    Visibility Map (greatly reduces vacuum overhead for slowly-changing tables)

    Version-aware psql (backslash commands work against older servers)

    Support SSL certificates for user authentication

    Per-function runtime statistics

    Easy editing of functions in psql

    New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin


Beta Information Page:
http://www.postgresql.org/developer/beta

Release Notes:
http://www.postgresql.org/docs/8.4/stat ... e-8-4.html

Source Code:
http://www.postgresql.org/ftp/source/v8.4beta/
User avatar
SQLDenis
LTD Admin
LTD Admin
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
LTD Gold - Rating: 3467LTD Gold - Rating: 3467LTD Gold - Rating: 3467
 
Posts: 21784
Joined: Wed Oct 10, 2007 6:43 pm
Location: Princeton, New Jersey, USA,World, Solar System, Milky Way, Universe and Beyond
Unrated