About three weeks ago, I wrote a blog post about the forthcoming end of the PostgreSQL 9.1 development cycle, and the many large and important features for which we have patches outstanding. Since we now have just 11 days to go before the beginning of the forth and final CommitFest, this seems like a good time to revisit the progress we've made. Here again is the list of features from my previous post:
1. SQL/MED. Over Christmas, I committed a chunk of this work, after heavy revisions. As a result, the CREATE FOREIGN TABLE, ALTER FOREIGN TABLE, and DROP FOREIGN TABLE commands now exist in PostgreSQL. However, foreign tables can't actually be queried yet. For that to happen, we need support for "foreign table scans". We are currently waiting for an updated patch.
2. Extensions. Dimitri Fontaine has continued to update his patch set, and is working on a further patch to allow extensions to be upgraded, but to the best of my knowledge no committer has yet agreed to work on getting this committed.
3. Synchronous Replication. Activity on this appears to have kicked into high gear again, with Simon Riggs taking the lead, but a final patch has not yet been submitted. Several small patches to improve replication in other ways and/or simplify the final patch are under way also.
4. Writable CTEs. To the best of my knowledge, Tom Lane is still planning to handle this patch, but no movement yet.
5. Per-column collation. No activity.
6. MERGE. There has been further discussion of this patch, by Greg Smith and others, but I believe there's still a significant amount of code review that needs to be done.
7. Checkpoint improvements. Greg Smith reports that he is still working on this, but no updated patch yet.
8. SE-Linux integration. I committed the last bits of infrastructure that I believe we need for a bare-bones implementation of this feature on December 13. KaiGai Kohei posted a stripped down sepgsql contrib module on December 23. I plan to review it, but have not had time yet.
9. Unlogged tables. Committed! For some test results, see depesz's blog post on unlogged tables.