PostgreSQL is a robust relational database system with more than 20 years of active development that runs on all major operating systems. It is fully ACID compliant, and has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, and ODBC, among others, and exceptional documentation.
Changes: GROUP BY processing has been improved by using hash buckets. There is a new multikey hash join capability. Queries using the explicit JOIN syntax are now better optimized. There is faster and more powerful regular expression code, full support for IPv6 connections and IPv6 address data types, and major improvements in SSL performance and reliability. The free space map efficiently reuses empty index pages. There is an SQL-standard information schema, a new client-to-server protocol, a new version of full-text indexing, and a new autovacuum tool. libpq and ECPG applications are now fully thread-safe.
Release Tags: Stable, Major feature enhancements
Continue reading " PostgreSQL 7.4 "