Weekly News - February 19th 2005

PostgreSQL Weekly News - February 19 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.

PostgreSQL Product News

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/

PostgreSQL in the News

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/