search

getfider / fider

Open platform to collect and prioritize feedback
https://fider.io
GNU Affero General Public License v3.0
2.75k stars 620 forks source link

Added migration to create missing posts.user_id index #1169

Open mway-niels opened 3 weeks ago

mway-niels commented 3 weeks ago

Issue:

As the number of users and/or posts grows, search performance goes down significantly (query duration >= 30s in our case).

Indexing the user_id column in the posts table fixes the issue.

mattwoberts commented 4 days ago

Cheers @mway-niels ! Looks like a sensible index to have. I'll bring this in soon.