Weekly News - February 19th 2005
There was a lot of discussion on the subject of preventing catastrophic transaction id (TID) wrap-arounds this week. It looks like pg_autovacuum is going to be part of 8.1.
OSCON submissions are now in process. If you got yours in, people are discussing it even now.
Sean Chittenden is using Coverity's code auditing tool on the PostgreSQL code base, and has found some bugs. http://www.coverity.com/
Abhijit Menon-Sen found a case where INSERT ... SELECT ... could crash the back-end. Although this did not corrupt data, Tom Lane fixed it in under four hours.
PGCluster-1.3.0 is a Synchronous Multi-Master replication system for PostgreSQL 8. http://www.pgfoundry.org/projects/pgcluster
MyGeneration O/R mapping tool now supports PostgreSQL http://www.mygenerationsoftware.com/
Formalized code quality checking is in the air. Klocwork has offered its static analysis tool to open source organizations including PostgreSQL http://www.klocwork.com/
Linuxworld Boston had a successful PostgreSQL presence. Kudos to all the folks in Boston who pulled this all together.
Latest from the Power PostgreSQL web site includes Mark Kirkwood's explanation of how the planner uses statistics and a brand new annotated postgresql.conf. http://www.powerpostgresql.com/
General Bits: http://www.varlena.com/GeneralBits/