8.2

• Memory settings in the postgresql.conf file can be specified in standard units such as '1 MB', instead of simply raw integers whose settings depends on the server units.
• Indexes can be created concurrently, without blocking writes to the table.
• You can watch the autovacuum daemon work in pg_stat_activity, and it records what it has done in views such as pg_stat_user_tables.
• Tables and indexes can have a FILLFACTOR that allows better clustering when inserting data out of order.
• The seq_page_cost configuration parameter was added, allowing easier fine tuning of how expensive the query planner thinks sequential and random I/O are.
• Several features were improved allowing more useful warm-standby server setups for disaster recovery failover.
• COPY can dump the results of an arbitrary query out, allowing that high-performance output path more targeted data replication capabilities. A faster binary COPY was also added.
• Initial support for DTrace was added. The number of things...