PostgreSQL-7.4.1
Reported by: |
igor@… |
Owned by: |
billyoc@… |
Priority:
|
high
|
Milestone:
|
|
Component:
|
BOOK
|
Version:
|
~CVS
|
Severity:
|
normal
|
Keywords:
|
VERIFIED
|
Cc:
|
|
|
|
Major release.
- 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
Version increment.