PostgreSQL version 8.3 Released
I just got word that version 8.3 of PostgreSQL has been released. Along with the usual amount of improvements there are some new features in 8.3 that should be of interest to PostgreSQL admins and developers such as:
- Integrated TSearch
- ENUM and UUID data types
- Faster sorting technique used for LIMIT operations
- Faster LIKE and ILIKE operations
- Lazy XID assignment which will make many read only operations much faster
Check out the full list of features at the PostgreSQL site or download it from the download section of their site.
RSS Feed
I think you missed the thing that'll make the biggest speed difference: asynchronous commits. In playing with the 8.3 rcs it's nearly as fast as running with fsync off, but without the corrupt-the-entire-database-on-power-loss risk. I'm *super* happy about async. commit.
Posted by Jacob Kaplan-Moss on Feb 4, 2008 at 1:59 AM