From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | Matt Christian <matt(at)summersault(dot)com> |
Cc: | pgsql-advocacy(at)postgresql(dot)org, Mark Stosberg <mark(at)summersault(dot)com> |
Subject: | Re: time sensitve: comparing performance to MySQL |
Date: | 2003-10-02 18:59:52 |
Message-ID: | 1065121192.24250.11.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
I think your best bet is to list the features your using from oracle and
then mark whether mysql / postgresql support those features, and how
much work might be involved in working around missing features.
heres some links in case you missed them:
http://www.serverwatch.com/news/article.php/10824_1126981_Ext_2
http://faemalia.org/wiki/view/Technical/PostgreSQLvsMySQL
http://www.sitepoint.com/article/529/1
http://www.phpbuilder.com/columns/tim20001112.php3?page=1
/
http://www.hwaci.com/sw/sqlite/speed.html
http://www.sergeant.org/sqlite_vs_pgsync.html
the above two go together, the first is sqlite/mysql/postgresql, the
second a tuned version of postgresql. note it's an older version of
pgsql
/
Robert Treat
On Thu, 2003-10-02 at 12:59, Matt Christian wrote:
> Hello,
>
> I've been tasked to do some quick research on Postgres vs. MySQL that I
> need to present later today. I've already done a lot of Googlin' and
> reviewing of the Postgres websites.
>
> The project at hand will be a high-volume website with many complex
> queries. It will likely use replication. Performance will be most
> important for SELECT statements.
>
> The project will be ported form an existing codebase which uses Oracle
> as the backend.
>
> I understand that Postgres has been closing the speed gap with MySQL,
> but I'm having trouble finding hard data on this. What specific
> information is available in this area?
>
> Your help is appreciated!
>
> --Matt
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Anastasios Hatzis | 2003-10-02 21:31:21 | Eric S. Raymond about Sun's troubles |
Previous Message | Merlin Moncure | 2003-10-02 17:24:20 | Re: time sensitve: comparing performance to MySQL |