PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, SunOS, Tru64), BeOS, and Windows. It is fully ACID compliant, 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, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
Here are a list of articles about new features in 8.3:
-PostgreSQL 8.3 Cheat Sheet Overview
-Synchronized Scans
-PostgreSQL 8.3 Features: Arrays of Compound Types
-PostgreSQL 8.3 Features: Plan Invalidation
-Optimizing function calls in PostgreSQL 8.3
-PostgreSQL 8.3 Features: Enum Datatype
-work_mem tuning and log_temp_files
-Converting tsearch2 to 8.3 (also note the manual section Migration from Pre-8.3 Text Search)
-Integrated Security in PostgreSQL 8.3
-Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration
-PostgreSQL Performance Features in 8.3
-Source material: PostgreSQL Blog’s 8.3 Feature Round-Up
Download: PostgreSQL 8.3.2 | 25.34 MB
No comments:
Post a Comment