Leverage your PostgreSQL V8.1 skills to learn DB2

From: "Ian Harding" <harding(dot)ian(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Leverage your PostgreSQL V8.1 skills to learn DB2
Date: 2006-04-12 16:28:28
Message-ID: 725602300604120928h78695a4fj57094bf2568e003@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-04-12 16:31:50 Re: Hardware related question: 3ware 9500S
Previous Message Anton Andreev 2006-04-12 16:00:48 table as hashtable