newhouseb

The basic idea here is to substantiate the claims made by this square post:
http://corner.squareup.com/2011/06/postgresql-data-is-important.html

In PostgreSQL, and MySQL (MyISAM and InnoDB) I create millions of rows and then add 
and remove columns and add and remove indexes.  For columns without defaults this is
basically free in PostgreSQL and O(n) in MySQL.  For adding indexes its at best O(n) 
everywhere, but with PostgreSQL it claims not to do any locking that would otherwise
prevent table interaction.

Also, PostgreSQL has _awsome_ documentation (it has real examples!). I always get