Feeds

PostgreSQL trumpets 8.4 release

More junk in the trunk

Combat fraud and increase customer satisfaction

The open source project behind the PostgreSQL relational database is blowing its nose trumpeting the availability of PostgresSQL 8.4, a rev that includes 293 new or improved features that make the database easier to administer and more useful to programmers and end users.

The new code, which is available for download here, was set to launch on June 29, but had a show-stopper bug that needed to be fixed at the last minute, according to Josh Berkus, a member of the PostgreSQL core development team. The bug related to the standby database failover feature of PostgreSQL that could have potentially caused some data loss for certain setups, so Berkus held up the release for two days to test a bug fix. (The bug fix worked, and if it didn't, then PostgreSQL 8.4 would still not be available).

While there are a plethora of features that database administrators and programmers are going to eat up, the big enhancements in PostgreSQL 8.4 include the ability to do a parallel database restore (which can speed up database recovery time by a factor of two to eight, depending on the underlying iron and how you set it up) and the ability to do "in-place" upgrades from PostgreSQL 8.3 to 8.4 "without extensive downtime." (It would be best, of course, to have no downtime. That's why companies that can't take downtime have high availability clustering of their database servers). This pg_Migrator tool is still in beta, by the way.

PostgreSQL also includes a new set of query monitoring tools, to allow administrators to monitor end users and see what queries they are launching at the database. (Some users, particularly in marketing, are fond of launching complex queries during peak transaction loads and inadvertently cripple system throughput with their crafty questions).

The updated database also includes ANSI SQL2003 features such as recursive joins, windowing functions, and common table expressions, features which allow end users to pose different kinds of questions of their databases that was possible with PostgreSQL 8.3 and earlier releases. There are enhancements to stored procedures, such as default parameters and variadic parameters, that the project says makes database programming more simple and compact as well.

The blow-by-blow feature list for PostgreSQL 8.4 is in the release notes, and the project has put together a feature matrix so you can see the evolution of PostgreSQL from the 7.4 though 8.4 releases. PostgreSQL 8.4 comes in pre-compiled binaries for FreeBSD, Linux, Mac OS X, Solaris (the x64 version of Solaris 10 only), and Windows operating systems. If you are a real do-it-yourselfer, it is possible to compile PostgreSQL source code to run on AIX, HP-UX, SCO UnixWare and OpenServer, and Irix Unixes, and it can run on just about any chip architecture you can name, as the release notes show. ®

3 Big data security analytics techniques

More from The Register

next story
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
Inside the Hekaton: SQL Server 2014's database engine deconstructed
Nadella's database sqares the circle of cheap memory vs speed
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Oh no, Joe: WinPhone users already griping over 8.1 mega-update
Hang on. Which bit of Developer Preview don't you understand?
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
Windows 8.1, which you probably haven't upgraded to yet, ALREADY OBSOLETE
Pre-Update versions of new Windows version will no longer support patches
IRS boss on XP migration: 'Classic fix the airplane while you're flying it attempt'
Plus: Condoleezza Rice at Dropbox 'maybe she can find ... weapons of mass destruction'
prev story

Whitepapers

Top three mobile application threats
Learn about three of the top mobile application security threats facing businesses today and recommendations on how to mitigate the risk.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
SANS - Survey on application security programs
In this whitepaper learn about the state of application security programs and practices of 488 surveyed respondents, and discover how mature and effective these programs are.