Download of the day: PostgreSQL 8.2

Posted by Vivek Gite [Last updated: December 30, 2006]

PostgreSQL 8.2 has been released and available for download.

PostgreSQL is a Free object-relational database server (database management system), released under a flexible BSD-style license.

This release adds many functionality and performance improvements that were requested by users, including:
=> Query language enhancements including INSERT/UPDATE/DELETE RETURNING, multirow VALUES lists, and optional target-table alias in UPDATE/DELETE
=> Index creation without blocking concurrent INSERT/UPDATE/DELETE operations
=> Many query optimization improvements, including support for reordering outer joins
=> Improved sorting performance with lower memory usage
=> More efficient locking with better concurrency
=> More efficient vacuuming
=> Easier administration of warm standby servers
=> New FILLFACTOR support for tables and indexes
=> Monitoring, logging, and performance tuning additions
=> More control over creating and dropping objects
=> Table inheritance relationships can be defined for and removed from pre-existing tables etc
=> Read Release Notes for more information

Download PostgreSQL 8.2.

A dump/restore using pg_dump is required for those wishing to migrate data from any previous release.

Tell us how we're doing: Please answer a few questions about your experience to help us improve nixCraft.