PostgreSQL 8.3 is currently in Beta 4 and promises to offer some whoppingly neat features. First before we go over the new features we are excited about in this upcoming release, we'd like to briefly cover what was added in past releases.
The big 8.0 Highlights
The biggest feature in 8.0 was native support for Windows
Dollar quoting syntax for stored functions which made it a lot easier to write stored functions since instead of having to escape quotes you could use the $something$ body of function $something$ delimiter approach.
Next favorite was - Tablespaces so that people no longer needed to resort to messy symlinks to simulate this needed feature
Save points, and improved buffer management.
Introduced Bitmap indexes which allowed for ability to use multiple indexes on a table simultaneously and less need for compound indexes.
Auto vacuuming. Auto Vacuuming was a huge benefit that all could appreciate. It allowed for automatic cleaning of dead space without human or scheduled intervention.
Also introduced in this release was improved shared locking and two phase commit
change in security - introducing login roles and group roles plus prevention of dropping roles that owned objects.
Constraint exclusion which improved speed of inherited tables thus improving table partitioning strategies.
Improved indexed creation that no longer required blocking concurrent insert, create, delete.
Ability to remove table inheritance from a child table without having to rebuild it.
Aggregates that can take multiple inputs and SQL:2003 statistical functions
Introduction of Fill Factor for tables similar to Microsoft SQL Server's Fill Factor functionality
8.3 upcoming Highlights
8.3 has numerous highlights just as previous versions, but we shall focus on our favorite ones.
Support Security Service Provider Interface (SSPI) for authentication on Windows - which presumably will allow PostgreSQL databases to enjoy the same single signon you get with Microsoft SQL Server 7-2005.
GSSAPI with Kerberos authentication as a new and improved authentication scheme for single signon