PostgreSQL Keeps Evolving: Better Performance, Irix Dies

For those not closely watching the latest upstream developments of the PostgreSQL database server, a number of changes have been made recently to advance this major open-source project.

You can monitor PostgreSQL on Anzwix for all of the latest developments for the open-source database server, but some of the highlights include:

Performance Improvements - On Saturday was a performance improvement made for most built-in PostgreSQL aggregate numeric functions like SUM(), AVG(), STDDEV(), VARIANCE(), etc.

IRIS Dropping - The IRIX port to PostgreSQL has been removed. SGI is planning to end its IRIX operating system support around next month and hasn't shipped on any new hardware in years, so the PostgreSQL support is being eliminated.

Extended Cube On-Disk Format - Points are now more tightly packed for a benefit of disk savings.

Reworked SSL Renegotiation - The SSL renegotiation code has been reworked and some bugs have been fixed in the process.

Many Other Changes - PostgreSQL continues to receive new additions in Git almost daily.