PostgreSQL 8 Officially ReleasedBy Blane Warrene
PostgreSQL 8 was officially released this week and has many new features to bring to the open source database table (so to speak).
Of course front and center would be the long awaited native Win32 binary that allows PostgreSQL to run natively on Windows 2000, XP and 2003 as a service. A separate project is underway to ease installation and can be found on the pgFoundry web site (recommended by Postgres).
Other features with an eye toward high performance and stability are point in time backup and restore, which allows for continuous backups and user’s choice for restore points, and tablespaces, which allow for tables and indexes to be stored on different (or the same) filesystems. This latter being an excellent option when tweaking for performance or managing drive space.