PostgreSQL 9.3 Beta 1 Released
From the post:
The first beta release of PostgreSQL 9.3, the latest version of the world’s best open source database, is now available. This beta contains previews of all of the features which will be available in version 9.3, and is ready for testing by the worldwide PostgreSQL community. Please download, test, and report what you find.
Major Features
The major features available for testing in this beta include:
- Writeable Foreign Tables, enabling pushing data to other databases
- pgsql_fdw driver for federation of PostgreSQL databases
- Automatically updatable VIEWs
- MATERIALIZED VIEW declaration
- LATERAL JOINs
- Additional JSON constructor and extractor functions
- Indexed regular expression search
- Disk page checksums to detect filesystem failures
In 9.3, PostgreSQL has greatly reduced its requirement for SysV shared memory, changing to mmap(). This allows easier installation and configuration of PostgreSQL, but means that we need our users to rigorously test and ensure that no memory management issues have been introduced by the change. We also request that users spend extra time testing the improvements to Foreign Key locks.
If that isn’t enough features for you to test, see the full announcement! 😉