News for hackers. Stuff that matters.
Re:Full-Text Search in Django with PostgreSQL by RasputinsBro on Saturday January 06, 2018 @12:56PM (#16086501)
I second this. You can't let your queries take unusable amounts of time, but below a certain threshold relevancy is infinitely more important.

I'm putting together a product which has a search feature and that uses Django + MySQL and I'm struggling with relevancy. I'd happily accept 500ms queries if that guaranteed me the relevant hit would be on the first page. That's FAR more usable than 50ms queries and then the relevant hit is on page 5.

Re:Full-Text Search in Django with PostgreSQL by brightball on Saturday January 06, 2018 @02:39PM (#16087027)
Full text search in MySQL isn’t in the same ballpark as PG. Thats not a dig at MySQL, just praise for the quality of what you get from the PG implementation.
Re:Full-Text Search in Django with PostgreSQL by orf on Saturday January 06, 2018 @02:44PM (#16087046)
Why mysql? Search in pg is waaay better.
Re:Full-Text Search in Django with PostgreSQL by pauloxnet on Saturday January 06, 2018 @07:36PM (#16088353)
Yes I think you need both of them of course and I found it on my project with Django and PostgreSQL.