Non buzzword feature list
Posted Nov 18, 2003 8:37 UTC (Tue) by
cpetig (guest, #13241)
Parent article:
PostgreSQL 7.4 Released
Here is the buzz word free feature list from the pgsql-announce mailing list:
! IN/NOT IN subqueries are now much more efficient
Improved GROUP BY processing by using hash buckets
New multikey hash join capability
Queries using the explicit JOIN syntax are now better optimized
Faster and more powerful regular expression code
Function-inlining for simple SQL functions
Full support for IPv6 connections and IPv6 address data types
Major improvements in SSL performance and reliability
! Make free space map efficiently reuse empty index pages, and other
SQL-standard information schema
Cursors conform more closely to the SQL standard
Cursors can exist outside transactions
! New client-to-server protocol
! libpq and ECPG applications are now fully thread-safe
New version of full-text indexing
New autovacuum tool
Array handling has been improved and moved into the server core
The exclamation sign marks features I value most.
Side note: The new c-t-s protocol features architecture independant binary transmission and query parameters!
As usual I can't imagine how I ever did without.
(
Log in to post comments)
