E.22.1. Migration to version 8.0.10

A dump/restore is not required for those running 8.0.X. However, if you are upgrading from a version earlier than 8.0.6, see the release notes for 8.0.6.

E.22.2. Changes

• Improve handling of getaddrinfo() on AIX (Tom)

  This fixes a problem with starting the statistics collector, among other things.

• Fix "failed to re-find parent key" errors in VACUUM (Tom)

• Fix race condition for truncation of a large relation across a gigabyte boundary by VACUUM (Tom)

• Fix bugs affecting multi-gigabyte hash indexes (Tom)

• Fix possible deadlock in Windows signal handling (Teodor)

• Fix error when constructing an ARRAY[] made up of multiple empty elements (Tom)

• Fix ecpg memory leak during connection (Michael)

• to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for new initdb installs (Tom)

  This is because lc_numeric can potentially change the output of these functions.

• Improve index usage of regular expressions that use parentheses (Tom)

  This improves psql \d performance also.

• Update timezone database

  This affects Australian and Canadian daylight-savings rules in particular.