This release contains a variety of fixes from 7.4.14. For information about new features in the 7.4 major release, see Section E.153, « Release 7.4 ».
A dump/restore is not required for those running 7.4.X. However, if you are upgrading from a version earlier than 7.4.11, see Section E.142, « Release 7.4.11 ».
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 bugs affecting multi-gigabyte hash indexes (Tom)
Fix error when constructing an ARRAY made up of multiple empty elements (Tom)
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.