Another major addition to the software is a tool that would make it easier for administrators to upgrade a Postgres database to a new version, called Pg_migrator. For past releases, especially with terabyte-sized databases, upgrading was "a painful process," Momjian admitted. The old process involved basically moving the entire contents of the database into a new file structure.
The new version allows the data to stay in place and only replaces the table layouts, a process that should take only a minute or so, even with terabyte-sized databases. "You can migrate a 400GB database in 40 seconds," Momjian said, pointing to a YouTube video he made demonstrating the process.
Beyond these major additions, "there's been a lot of overhaul" of Postgres in general, warranting the jump in major release numbering, from version 8 to version 9, Momjian said. Support for stored procedures has been expanded, allowing for new types of procedures to be executed. The Perl compiler has been overhauled, and the Python compiler can work with version 3 of that language.
A lot of these smaller features should also encourage enterprise use. For instance, permissions management -- which specifies who gets to see which parts of the database -- has been revamped.
Also, the software can now show administrators which applications are making which calls to the database, Momjian said. "When an application connects to the database, it can supply its name," and, in turn, this name is shown on the administrator console for looking at queries, he said.