pleroma

commit: 03952a27600b0947c415a72655262eaa37804d23
parent f039c9c19a95e414a641c5209e11b946d939dcfc
Author: Roger Braun <roger@rogerbraun.net>
Date:   Sat, 16 Sep 2017 14:51:55 +0200

Sort by updated_at

the updated_at column isn't indexed, so postgres won't take the wrong index.

Diffstat:
M
lib/pleroma/web/twitter_api/twitter_api.ex
3
++-

1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/lib/pleroma/web/twitter_api/twitter_api.ex b/lib/pleroma/web/twitter_api/twitter_api.ex
@@ -212,7 +212,8 @@ defmodule Pleroma.Web.TwitterAPI.TwitterAPI do
       where: fragment("?->>'type' = 'Create'", a.data),
       where: fragment("to_tsvector('english', ?->'object'->>'content') @@ plainto_tsquery('english', ?)", a.data, ^query),
       limit: ^limit,
-      offset: ^offset
+      offset: ^offset,
+      order_by: [desc: :updated_at] # this one isn't indexed so psql won't take the wrong index.
 
     activities = Repo.all(q)
     activities_to_statuses(activities, %{for: user})