Download of the day: PostgreSQL 8.2

last updated in Categories Download of the day
PostgreSQL Logo

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.

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.

Share this on (or read 4 comments/add one below):

4 comment

    Have a question? Post it on our forum!