FreeBSD ports tree https://cgit-dev.freebsd.org/ports/atom?h=main 2018-02-10T22:03:15Z 2018-02-10T22:03:15Z Rene Ladan rene@FreeBSD.org 2018-02-10T22:03:15Z urn:sha1:2a60d94fd7129acb2447f23051a7fb768405aa67 2018-01-01 devel/p5-Parse-Pidl: yes 2018-02-08 devel/rubygem-piston: No longer maintained upstream 2017-04-05 databases/postgresql92-server: PostgreSQL 9.2 support has reached End-of-line. Please upgrade to a later version. 2009-07-08T06:57:26Z Palle Girgensohn girgen@FreeBSD.org 2009-07-08T06:57:26Z urn:sha1:48e19315dbd5f66e734f2d982642dd15a21d034d 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 URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html