On Fri, Jun 25, 2010 at 1:22 AM, John Gage <jsmgage@numericable.fr> wrote:
> There are features, are there not, that Postgres has that MySQL does not
> have?
>
> I refer in particular to things like tsvector.
>
> Am I mistaken in this?
>
> John
>
>
> On Jun 25, 2010, at 3:46 AM, Rob Wultsch wrote:
>
>> unless there was a specific reason to migrate
>
>
MySQL has several full text search solutions. The built in MyISAM
solution is the best known, but there is also an engine for using
sphinx.
...
And there are features that MySQL has that PG does not. Index only
queries is a massive feature. Pluggable backend storage engines are
another. MySQL is also somewhat simpler to tune.
Both systems can work well. Both have advantages. Both can suck.
As has been just demonstrated, both have communities that suck at
mingling with the other major open source rdms.
--
Rob Wultsch
wultsch@gmail.com