[retinaros]

Just pgsql is enough. Even a chache db or sqlite do full text search

[alias_neo]

I'm not familiar with the various search features of different databases.

Do they offer things like the phonetic search that Solr does?

With Solr you can search a noun for example even if you only know how to say it and not how to spell it.