Re: Postgres v MySQL 5.0

On 1/19/2007 12:32 PM, Brian Hurt wrote:
> Good comparison (for Postgres, anyways) from digg:
>
> http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html

I liked particularly this user comment:

"Now, the MySQL performance using the new techniques beats Postgres
performance using the old techniques."

So optimizing a crappy database for MySQL makes it faster than running
the crappy database on Postgres ... I never expected that one.


Jan


>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #