This is interesting. http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603wasserman2/
There are a few bugs 1. In the graphic overview PostgreSQL == Progres 2. In description of PostgreSQL database cluster, "After initialization, a database cluster contains a database called postgres, which is a default database used by utilities, users and third party applications. " That doesn't seem to be necessarily true. I don't have that database.... 3. He misses the fact that some configuration options can be set interactively via SET 4. "The VACUUM command must be run on a regular basis to recover disk space occupied by updated or deleted rows and to update data statistics used by the PostgreSQL query planner. " with no mention of autovacuum. He is talking about 8.1. Every time I learn about a big commercial database I am amazed at how much 'bigger' and more complicated than PostgreSQL they are - I guess they have to be for their intended use - and how similar to PostgreSQL they are in actual function. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
