Waiting for 8.4
From PostgreSQL wiki
Jump to navigationJump to searchThe 8.4 Release Notes briefly mention all of the features in the new version.
Waiting for 8.4
The "Waiting for 8.4" series from Hubert Lubaczewski covers features added to 8.4 as they are committed. A similar listing to this one is presented in "final post" or you can just go directly to series index:
- final post (?)
- no more -d in pg_dump!
- parallel restoration of dumps
- window functions
- pg_stat_statements
- remove system objects from \dX
- Window Functions - teaser
- Default values for function arguments + integer in any base
- Visibility maps
- TABLE
- auto-explain
- array aggregate and array unpacker
- suppress_redundant_updates_trigger
- Waiting for 8.4 - sql-wrappable RETURNING
- pl/* srf functions in selects
- Common Table Expressions (WITH queries)
- new FSM (Free Space Map)
- database-level lc_collation and lc_ctype
- pgbench with timed execution
- case insensitive text ( citext )
- UNION / INTERSECT / EXCEPT
- ordered data loading in pg_dump
- hash based DISTINCT
- RETURNS TABLE
- variadic functions
- storage types for table columns
- sequence details
- timing on/off
- partial-match support in GIN, and sequence restart
- CASE in pl/PgSQL
- function stats
- pl/PgSQL RAISE
- psql vs. tabs + wrapped output
- pg_conf_load_time, time-related generate_series and enum values in \dT+
- RETURN QUERY EXECUTE and cursor_tuple_fraction
- \o and \d+ in psql
- generate_subscripts
- “EXPLAIN VERBOSE”
- current_query()
- EXECUTE USING in plpgsql
- \l+ and \d in psql
- Statement-level ON TRUNCATE triggers
- quote_nullable()
- Report queries in a deadlock
- enum type for guc parameters
- limit (select ) and optional as in select
8.4 Talks and Discussion
- Intro to Postgres 8.4 Tutorial by Robert Treat
- What's new in PostgreSQL 8.4 by Magnus Hagander
- What's your favorite 8.4 feature?
- PostgreSQL 8.4 Beta: "We've got momentum"
- David Fetter talks: "Trees and More in SQL" and "Windowing Functions: Putting the TPS in TPS Reports" cover 8.4 features
- Upcoming PostgreSQL Features by Bruce Momjian