How much more efficient is Postgres than MYSQL in full-text search?

Question

I was a MYSQL user, I have never tried Postgres.

But MYSQL has a bottle neck in a full-text search when the data set is huge.

Answer 1

A few years ago, I ran tests on large data sets and found that:

• MySQL FULLTEXT

. , MyISAM , . , : , , . , , , Wikipedia ...

• PostgreSQL

10-100 , MySQL fulltext, , gist /, , , .

, , RAM - MVCC, postgres , . , . 10 , . , SELECT WHERE ( ) ORDER BY date LIMIT 10, 10.000 , . , MySQL, , .

• Xapian: , Lucene Sphinx, .

Xapian , , . , concurrency, - . . , , , , , .

, , , . , .

, Postgres IO-seek, MySQL , Xapian .

, . , . , , . , postgres . , , .

Answer 2

, Postgres mysql, . , , , Sphinx Lucene. Sphinx , mysql. .

. php mysql fulltext search: lucene, sphinx ? my original ( )

Answer 3

, , .

, GIN , /. , GIST, ( ), /.

, , , sphinx lucene . PostgreSQL , . . . . , . db, , , .

Answer 4

, ; .

Personally, I would be surprised if there would be a significant difference, I would suggest that this kind of performance is limited by IO bandwidth.