From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Tzvetan Tzankov <tzankov(at)noxis(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL 8.1 vs. MySQL 5.0? |
Date: | 2005-10-08 15:22:14 |
Message-ID: | 4347E426.2080706@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general |
On 10/6/2005 4:37 AM, Tzvetan Tzankov wrote:
> They have collation and multiple characterset per table and etc. which
> actually is from 4.1 (not new in 5.0), and postgresql have only one
> collation per database cluster :-(
> Otherwise I think their features are all there, but cannot be used
> togather most of them (you can have foreign key, but not using fulltext ...)
AFAIK MySQL's fulltext indexing is only supported on MyIsam tables, so
if you want to use it, you lose ACID, hot backup and a couple other nice
things entirely for that part of your data. Many MySQL users still
believe that the pluggable storage engine design is an advantage ... I
think one storage engine that supports the full feature set is better.
Jan
>
> CSN wrote:
>> Just so I know (and am armed ;) ), are there any new
>> comparable features in MySQL 5.0 that aren't in
>> PostgreSQL up to the forthcoming 8.1? AFAIK, PG just
>> lacks updatable views (which are on the TODO).
>>
>> MySQL 5.0 new features
>> http://dev.mysql.com/doc/mysql/en/mysql-5-0-nutshell.html
>>
>> Thanks,
>> CSN
>>
>>
>>
>> __________________________________
>> Yahoo! Mail - PC Magazine Editors' Choice 2005
>> http://mail.yahoo.com
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2005-10-08 15:31:30 | Re: Oracle buys Innobase |
Previous Message | Andreas Kretschmer | 2005-10-08 08:34:45 | Re: Oracle buys Innobase |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2005-10-08 15:31:30 | Re: Oracle buys Innobase |
Previous Message | Nikolay Samokhvalov | 2005-10-08 14:05:29 | Re: PostgreSQL Gotchas |