Search on old posts

[sseerrggii]

We have a problem until we remove Elastic Search #568

The Post search only find new posts.

For exemple if you search (logged out) for "pagina" https://www.timeoverflow.org/offers?q=pagina

You will find one post from december of 2020 https://www.timeoverflow.org/offers/29150

but you have older post with "pagina" in text like https://www.timeoverflow.org/offers/769

@sauloperez suggest to update our database in order to update database indexes

[markets]

@sseerrggii @sauloperez As per https://github.com/Casecommons/pg_search/wiki/Building-indexes, we can try running the following command (staging first) in console: ActiveRecord::Base.connection.execute("UPDATE posts SET id = id") to avoid touching the updated_at attribute, in case that command didn't work, we can run: Post.find_each(&:touch) (DOWNSIDE all posts will update the updated_at attribute)

[sseerrggii]

It works @markets

I tried in staging first to execute ActiveRecord::Base.connection.execute("UPDATE posts SET id = id") and it works so I executed it in production too. Also the execution was really quick.

Thanks @markets and @sauloperez