Re: Which database? - Mailing list pgsql-advocacy

From Bruce Momjian
Subject Re: Which database?
Date
Msg-id 200306101932.h5AJWYs18793@candle.pha.pa.us
Whole thread Raw
In response to Re: Which database?  (Kaarel <kaarel@future.ee>)
Responses Re: Which database?  (Ewald Geschwinde <webmaster@geschwinde.net>)
List pgsql-advocacy
Kaarel wrote:
> > Depends on your needs
> > Mysql for smaller things.
>
> Does it mean MySQL is faster or more reliable with smaller amounts of data?

I think it is faster for simple, read-only (SELECT) queries on small data
sets.

Large data set, complex WHERE clause, non-SELECT, PostgreSQL is probably
faster --- plus we have more of the commercial database features.

Think MySQL as MSAccess, PostgreSQL as Oracle.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-advocacy by date:

Previous
From: Kaarel
Date:
Subject: Re: Which database?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] MySQL gets $19.5 MM