3 ms·

If you're using PostgreSQL you can take advantage of its full text search support. When doing so, make sure to save the text search vectors in a physical column

If you're using PostgreSQL you can take advantage of its full text search support. When doing so, make sure to save the text search vectors in a physical column as otherwise queries will be quite slow.

huskyr 12y ago
I would definitely take that option if we would use PostgreSQL, but we don't. PostgreSQL sounds like a wonderful piece of software, but they need to work on making it more accessible and user friendly. I tried getting something up and running, but given that there isn't a proper native client for Mac i gave up :(
- cglace 12y ago
  It is really easy to install using http://brew.sh/ http://brew.sh/
  - huskyr 12y ago
    The command-line part and executables are indeed, but it's lacking in visual tools. Say, the equivalents of Sequel Pro and Phpmyadmin.
    - ewams 12y ago
      http://www.pgadmin.org/ http://www.pgadmin.org/ http://phppgadmin.sourceforge.net/doku.php http://phppgadmin.sourceforge.net/doku.php