March 21st, 2002, 06:50 PM
postgres is similar to Oracle
I am a new convert to postgres. I have been working with
many RDBMS systems for about 4 years, and recently
became certified on Oracle.
So far from what I have seen, it seems to back up the
anecdotal evidence of what people have been saying,
that postgres is the Oracle of the Open Source world.
Particularly similar are the configuration options in the
configuration file, and the way postgres allocates memory.
The main difference I see is the mechanism by which postgres protects data, that being forcing hard commits to disk,
versus Oracle's multileveled redo/archive log system.
Personally I enjoy this difference as it reduces complexity
I feel confident with my data being safe. Keep up the good work