Help: Choosing PostgreSQL vs MySQL - Mailing list pgsql-general

From Simon Kwan
Subject Help: Choosing PostgreSQL vs MySQL
Date
Msg-id 028f01bf08aa$97206b50$110540ca@hk.super.net
Whole thread Raw
In response to Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc()  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
List pgsql-general
Hi greeting,
  I am new to Linux.
  Appreciate advise and comment on choosing between PosytgreSQL vs. MySQL.
Both to be run under Linux.  How does these two database compare with MS SQL
7.0?

 There are two options to configure the data base,
a) The data base will have a few million rows, each row is about 100 bytes.
One of the column (field) will be a pathname (filename) to index to an
external files for storing images. Each image belongs to a particular row
and image is 3 to 20 kb (variable size jepg files).

b) same as the about, but the image will be stored as one filed in the data
base. In this case, the data base will be much larger and wonder if it is
size is okay (speed, capacity, etc...)

Many thansk in advance. Appreciate email reply also.

Simon



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] FATAL 1: Memory exhausted in AllocSetAlloc()
Next
From: Simon Kwan
Date:
Subject: Help: Choose between PostgreSQL vs MySQL