pleroma

commit: 1266b180b912036fde72fa688eb7de99686ce47e
parent 1775a4db081f6764c358ac68bc0b5153a1a369fe
Author: Mark Felder <feld@feld.me>
Date:   Thu, 10 Apr 2025 14:32:31 -0700

Improved performance of status search queries using the default GIN index

Diffstat:
A
changelog.d/gin-search.fix
1
+
M
lib/pleroma/search/database_search.ex
3
++-

2 files changed, 3 insertions(+), 1 deletion(-)
diff --git a/changelog.d/gin-search.fix b/changelog.d/gin-search.fix
@@ -0,0 +1 @@
+Improved performance of status search queries using the default GIN index
diff --git a/lib/pleroma/search/database_search.ex b/lib/pleroma/search/database_search.ex
@@ -102,7 +102,8 @@ defmodule Pleroma.Search.DatabaseSearch do
           ^tsc,
           o.data,
           ^search_query
-        )
+        ),
+      order_by: [desc: :inserted_at]
     )
   end