I’ve very happy to see that PostgreSQL 8.0 is now officially released. There are all sorts of new features in 8.0 in several different areas. Here are some of the highlights:

  • Microsoft Windows Native Server
  • Savepoints
  • Point-In-Time Recovery
  • Tablespaces
  • Improved Buffer Management, CHECKPOINT, VACUUM
  • Change Column Types
  • New Perl Server-Side Language
  • Comma-separated-value (CSV) support in COPY
  • Support cross-data-type index usage
  • Add ability to prolong vacuum to reduce performance impact
  • Implement dollar quoting to simplify single-quote

Congrats to the whole PostgreSQL team, thank you for all of your hard work and diligence.

UPDATE 11:30am 19 Jan 2005: The announcement of PostgreSQL 8.0 is very popular, my PubSub watch list for “PostgreSQL” is just exploding with entries today.