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_2http://faemalia.org/wiki/view/Technical/PostgreSQLvsMySQLhttp://www.sitepoint.com/article/529/1http://www.phpbuilder.com/columns/tim20001112.php3?page=1
/
http://www.hwaci.com/sw/sqlite/speed.htmlhttp://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
