pleroma

commit: 99fbe0418a1bae703b6ae052c9ffd60c361f0249
parent 1775a4db081f6764c358ac68bc0b5153a1a369fe
Author: feld <feld@feld.me>
Date:   Thu, 10 Apr 2025 22:01:25 +0000

Merge branch 'gins-tonic' into 'develop'

Improved performance of status search queries using the default GIN index

See merge request pleroma/pleroma!4352
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