PostgreSQL 8.4 - SQL database server. (Free)

PostgreSQL for Mac is a collection of graphical tools for using and managing PostgreSQL servers, as well as the server itself installable on any Mac running OS X version 10.4.x. It should work on 10.3.9, but it is not officially supported in the configuration.

Also included as part of the package is the PGSQLKit framework, an open source framework for developers to leverage the power of PostgreSQL in their own applications.

WHAT'S NEW

Version 8.4: After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards. The major areas of enhancement are:

• Windowing Functions
• Common Table Expressions and Recursive Queries
• Default and variadic parameters for functions
• Parallel Restore
• Column Permissions
• Per-database locale settings
• Improved hash indexes
• Improved join performance for EXISTS and NOT EXISTS queries
• Easier-to-use Warm Standby
• Automatic sizing of the Free Space Map
• Visibility Map (greatly reduces vacuum overhead for slowly-changing tables)
• Version-aware psql (backslash commands work against older servers)
• Support SSL certificates for user authentication
• Per-function runtime statistics
• Easy editing of functions in psql
• New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin

REQUIREMENTS

Mac OS X 10.4 or later.

DEVELOPER

DOWNLOADS

10545