basically the same as the search box for stacksignature [comments] [contains | is exactly ] [enter search string here] we also need [URL] [contains | is exactly ] [enter search string here] but comments would really help out right now with the analysis. this will allow us to associate similar user provided commments with the crashes they are seeing.

recommending P2.

URLs aren't public, so I don't think it's safe to let everyone search on them. I'd love being able to search for specific comments, and also just being able to search for items that have comments at all.

Comments should be a no-brainer, except that column is probably not full-text indexed, so it will suck.

This WFM, but we'll still probably need an index on reports.comments to make this feasible.

Comment on attachment 314824 [details] [diff] [review] allow querying by comment This is going to hurt -- chofmann can you avoid putting these queries into a single page with 12 iframes? :)

morgamic: more than that, it will probably never succeed currently due to the table size. I really think we'll need an index before we can put this in production.

Yeah... I'd recommend using Tsearch2 to create a ftext index or use OpenFTS: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ http://openfts.sourceforge.net/ Anybody have experience w/ fulltext on postgres?

I've used tsearch2 before, so I can do the SQL-fu to get that setup, but my RHEL/CentOS admin skills are lacking, so I have no idea how to get the tsearch2 module installed. It appears to come in the postgresql-contrib package, but that's not in the base repo, so I'm sort of stuck.

Aravind: do you know what sort of effort it would take to get tsearch2 installed?

installed it on khan.

Do with other search bugs.

This will now be 2.x

Actually searching into the users' comments would be really simple to solve with ES (almost as simple as adding a box in the UI). For the URLs, see https://bugzilla.mozilla.org/show_bug.cgi?id=411417#c4 I don't know how hard it would be with PostgreSQL.

Now possible with supersearch for all users. For example: https://crash-stats.mozilla.com/search/?date=%3C%3D2013-10-02+10%3A00%3A00&user_comments=firefox&product=Firefox&_facets=signature&_columns=date&_columns=signature&_columns=product&_columns=version&_columns=user_comments