Re: selecting DB on linux

["A.Sajjad Zaidi" <sajjad@example.com>]

Postgres it is.

Version 7.0x was quite a bit faster than 6.x and was much more userfriendly.
7.1x is even faster and better.

Most of the servers I manage have 256MB RAM and around 550-800MHz cpu which is
more than enough for postgres. Disk usage is around 8MB for the software itself
and about 80MB for a decent sized database. Compare that to the few hundred MBs
required for an empty oracle db.

Ive even setup one customer that uses a cluster of 2 postgres database machines
and the performance is awesome. Of course the clustering is done by our
software, but postgres plays a big part in the performance.

asz


Jonathan Shore wrote:

> I'm moving away from oracle on Linux (a monster of a DB which was a
> nightmare to install and maintain) and looking to replace with another DB.
>
> I'm looking for a DB which has a balance of the following:
>
> *       conservative memory & cpu footprint (when not in use)
> *       db recoverability (machine may go up and down unexpectedly) [sounds
> bizzare but can explain if anyone is interested].
> *       reasonable performance, but with an architecture that can scale
> *       SQL compliance
>
> The first 2 bullets is especially important as will be using on devices with
> small memory footprints (256MB) and limited CPU time (other processes will
> dominate).  In this scenario, expect few transactions, mostly DB reads.
> [btw, never had any intention of using oracle in this scenario - wouldn't
> even get a server running in this env].
>
> Ideas on how postgresql, mysql, or other DBs would fit this profile?
>
> JS
>
>   ------------------------------------------------------------------------
>                   Name: winmail.dat
>    winmail.dat    Type: application/ms-tnef
>               Encoding: base64