PostgreSQL 8.4 released, focus on admin, monitoring

The PostgreSQL project has released version 8.4 of its namesake open source database system with some 300 new or improved features and a renewed focus on administration and monitoring tools.

PostgreSQL is used by thousands of organisations worldwide and is often regarded as the “enterprise grade” open source database compared with the more popular MySQL.

Notable enhancements in version 8.4 include parallel database restore for speeding up recovery from backup (by up to eight times); per-column permissions for more granular control of sensitive data; and per-database collation support to make PostgreSQL more useful in multi-lingual environments. PostgreSQL users include IMAN international, All Homes and shopping centre giant Westfield.

Also new in 8.4 is in-place upgrades through pg_migrator (beta) to enable upgrades from 8.3 to 8.4 without “extensive” downtime and new query monitoring tools to give administrators more insight into query activity.

Kevin Grittner, database administrator for the Wisconsin courts system, said the new release boosts application performance.

“Version 8.4 has added several optimisations, such as semi-joins and anti-joins, which provide dramatic improvement in the run time of some of our most demanding queries,” Grittner said.

According to the developers, version 8.4 makes data analysis easier through the advanced ANSI SQL2003 features of windowing functions, common table expressions and recursive joins.

Jeffrey Webster, CTO of ZooLoo.com, said: “We’ve used PostgreSQL for seven years now, and we’re really looking forward to many of the features in 8.4, particularly column permissions, per-database locale, partial matches for GIN indexes and user defined exceptions. PostgreSQL has allowed us to grow without sacrificing data integrity.”

The OpenStreetMap project is also a PostgreSQL user.

OpenStreetMap system administrator Tom Hughes said when the mapping service was planning the new version of its API, it needed a world-class database that runs well at the scale it needs.

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now