Appendix E. Release Notes
Major changes in this release:
Microsoft Windows Native Server
This is the ﬁrst PostgreSQL release to run natively on Microsoft Windows® as a server. It can
run as aWindows service. This release supports NT-based Windows releases like Windows 2000
SP4, Windows XP, and Windows 2003. Older releases like Windows 95, Windows 98, andWin-
dows ME are not supported because these operating systems do not have the infrastructure to
support PostgreSQL. A separate installer project has been created to ease installation on Win-
dows — see http://www.postgresql.org/ftp/win32/.
Although tested throughout our release cycle, the Windows port does not have the beneﬁt of
years of use in production environments that PostgreSQL has on Unix platforms. Therefore it
should be treated with the same level of caution as you would a new product.
Previous releases required the Unix emulation toolkit Cygwin in order to run the server on Win-
dows operatingsystems. PostgreSQL has supported native clients on Windows for many years.
Savepoints allow speciﬁc parts of a transaction to be aborted without affecting the remainder
of the transaction. Prior releases had no such capability; there was no way to recover from a
statement failure within a transaction except by aborting the whole transaction. This feature is
valuable for application writers who require error recovery within a complex transaction.
In previous releases there was no way to recover from disk drive failure except to restore from
aprevious backup or use a standby replication server. Point-in-time recovery allows continuous
backup of the server. You can recover either to the point of failure or to some transaction in the
Tablespaces allow administrators to select different ﬁle systems for storage of individual tables,
indexes, and databases. This improves performance and control over disk space usage. Prior
releases used initlocation and manual symlink management for such tasks.
Improved Buffer Management,
This release has a more intelligent buffer replacement strategy, which will make better use of
available shared buffers and improve performance. The performance impact of vacuum and
checkpoints is also lessened.
Change Column Types
Acolumn’s data type can now be changed with
NewPerl Server-Side Language
Anew version of the plperl server-side language now supports a persistent shared storage area,
triggers, returning records and arrays of records, and SPI calls to access the database.
Comma-separated-value (CSV) support in
can now read and write comma-separated-value ﬁles. It has the ﬂexibility to interpret non-
standard quoting and separation characters too.