PostgreSQL Blog's 8.3 Feature Round-Up

In [http://www.omniti.com/ OmniTI] world, as we work through evaluting and planning our first set of PostgreSQL 8.3 migrations, one nice resource we have used is the various blog postings over the past several months describing some of the new changes in 8.3. Since I figure this information would be handy to others, here is a meta post, rounding up all of the blog posts discussing new 8.3 features and changes. * [http://www.postgresonline.com/journal/index.php?/archives/17-PostgreSQL-8.3-Cheat-Sheet-Overview.html PostgreSQL 8.3 Cheat Sheet Overview], Leo Hsu and Regina Obe, 2008-01-05 * [http://j-davis.com/postgresql/83v82_scans.html Synchronized Scans], Jeff Davis, 2007-10 * [http://merlinmoncure.blogspot.com/2007/09/this-will-be-first-in-what-hopefully-be.html PostgreSQL 8.3 Features: Arrays of Compound Types] , Merlin Moncure, 2007-09-03 * [http://merlinmoncure.blogspot.com/2007/09/as-previously-stated-postgresql-8.html PostgreSQL 8.3 Features: Plan Invalidation], Merlin Moncure, 2007-09-04 * [http://www.postgresql-support.de/blog/blog_hans.html#blog1 Optimizing function calls in PostgreSQL 8.3], Hans-Jürgen SCHÖNIG, 2008-01-16 * [http://people.planetpostgresql.org/xzilla/index.php?/archives/320-PostgreSQL-8.3-Features-Enum-Datatype.html PostgreSQL 8.3 Features: Enum Datatype], Robert Treat, 2007-09-14 * [http://people.planetpostgresql.org/shoaibmir/index.php?/archives/7-work_mem-tuning-and-log_temp_files.html work_mem tuning and log_temp_files], Shoaib Mir , 2007-11-13 * [http://sql-info.de/postgresql/notes/converting-tsearch2-to-8.3.html Converting tsearch2 to 8.3], Ian Barwick, 2007-11-20 * [http://www.kaltenbrunner.cc/blog/index.php?/archives/22-feature-matrix-or-what-is-new-in-version-XY.html feature matrix - or “what is new in version XY?”],Stefan Kaltenbrunner , 2008-01-31 * [http://people.planetpostgresql.org/mha/index.php?/archives/155-Integrated-Security-in-PostgreSQL-8.3.html Integrated Security in PostgreSQL 8.3], Magnus Hagander, 2007-09-24 If you know of any posts discussing new 8.3 features I’ve missed, please lmk.