If search is your application's main purpose, you'll want something more flexible. Otherwise, it's fairly easy to implement, and you get full SQL support so jo

If search is your application's main purpose, you'll want something more flexible. Otherwise, it's fairly easy to implement, and you get full SQL support so joins, transactions, etc. So you can always prototype it and see what limitations you run into. If you're just getting started with Postrges, I have some examples of using its' FTS search here: http://monkeyandcrow.com/blog/postgres_railsconf2013/ http://monkeyandcrow.com/blog/postgres_railsconf2013/ It's targeted at Rails, but I always show the SQL first, so you should be able to adapt it.