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.
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 |