akkoma/priv
Oneric 31d277ae34
All checks were successful
ci/woodpecker/pr/test/2 Pipeline was successful
ci/woodpecker/pr/test/1 Pipeline was successful
ci/woodpecker/push/docs Pipeline was successful
ci/woodpecker/push/publish/4 Pipeline was successful
ci/woodpecker/push/publish/1 Pipeline was successful
ci/woodpecker/push/publish/2 Pipeline was successful
db: (re)add activity type index
Before 32a2a0e5fa the context index
acted as a (based on the name surprising) type index too.
Type-based queries are used in the daily pruning of old e.g. Delete
activities by PruneDatabaseWorker, when querying reports for the admin
API and inferring by the significant change in average execution time
a mysterious COUNT query we couldn’t associated with any code so far:

  SELECT count(a0."id") FROM "activities" AS a0 WHERE (a0."data"->>$2 = $1);

Having this as a separate index without pre-sorting results in
an overall smaller index size than merging this into the context index
again and based on it not having been sorted before non-context queries
appear to not significantly profit from presorting.
2026-01-11 00:00:00 +00:00
..
es-mappings Refactor ES on top of search behaviour 2022-06-30 16:28:31 +01:00
gettext Translated using Weblate (Chinese (Simplified Han script)) 2025-10-13 10:01:37 +00:00
repo db: (re)add activity type index 2026-01-11 00:00:00 +00:00
scrubbers Allow mastodon-style quotes 2025-10-24 00:00:00 +00:00
static Add banner.png back 2025-11-23 00:00:00 +00:00
templates Drop media base_url default and recommend different domain 2024-03-18 22:33:10 -01:00
language-codes.json Add language support on /api/v1/statuses 2023-01-10 10:29:17 +00:00