„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
* COPY TO can copy the output of an arbitrary SELECT statement
* Array improvements, including nulls in arrays
* Aggregate-function improvements, including multiple-input aggregates and SQL:2003 statistical functions
* Many contrib/ improvements“

PostgreSQL Release 8.2 Beta Release Notes

PostgreSQL Release 8.2 Beta Release Notes

Von admin

Ähnlicher Beitrag

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert