Re: time sensitve: comparing performance to MySQL

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