aboutsummaryrefslogtreecommitdiff
path: root/lib/mix/tasks/pleroma/database.ex
AgeCommit message (Collapse)Author
2022-08-20Switch to associated_object_id indexTusooa Zhu
2022-02-25Copyright bump for 2022Sean King
2021-08-15mix pleroma.database set_text_search_config now runs concurrently and infinitelysomeone
2021-06-07Update lib/mix/tasks/pleroma/database.exfeld
2021-05-08a better query to delete from hashtagsfaried nawaz
old query: Delete on hashtags (cost=5089.81..5521.63 rows=6160 width=18) -> Hash Semi Join (cost=5089.81..5521.63 rows=6160 width=18) Hash Cond: (hashtags.id = ht.id) -> Seq Scan on hashtags (cost=0.00..317.28 rows=17528 width=14) -> Hash (cost=5012.81..5012.81 rows=6160 width=20) -> Merge Anti Join (cost=0.70..5012.81 rows=6160 width=20) Merge Cond: (ht.id = hto.hashtag_id) -> Index Scan using hashtags_pkey on hashtags ht (cost=0.29..610.53 rows=17528 width=14) -> Index Scan using hashtags_objects_pkey on hashtags_objects hto (cost=0.42..3506.48 rows=68158 width=14) new query: Delete on hashtags ht (cost=0.70..5012.81 rows=6160 width=12) -> Merge Anti Join (cost=0.70..5012.81 rows=6160 width=12) Merge Cond: (ht.id = hto.hashtag_id) -> Index Scan using hashtags_pkey on hashtags ht (cost=0.29..610.53 rows=17528 width=14) -> Index Scan using hashtags_objects_pkey on hashtags_objects hto (cost=0.42..3506.48 rows=68158 width=14)
2021-05-08mix prune_objects: remove unused hashtags after pruning remote objectsfaried nawaz
2021-02-23[#3213] `mix pleroma.database rollback` tweaks.Ivan Tashkinov
2021-02-11Merge remote-tracking branch 'remotes/origin/develop' into ↵Ivan Tashkinov
feature/object-hashtags-rework # Conflicts: # CHANGELOG.md # lib/mix/tasks/pleroma/database.ex # lib/pleroma/web/templates/feed/feed/_activity.rss.eex
2021-02-07[#3213] Partially addressed code review points.Ivan Tashkinov
migration rollback task changes, hashtags-related config handling tweaks, `hashtags.data` deletion (unused).
2021-02-06Update priv/repo/migrations/20190501125843_add_fts_index_to_objects.exs, ↵hyperion
priv/repo/optional_migrations/rum_indexing/20190510135645_add_fts_index_to_objects_two.exs files
2021-01-31[#3213] Explicitly defined PKs in hashtags_objects and ↵Ivan Tashkinov
data_migration_failed_ids. Added "pleroma.database rollback" task to revert a single migration.
2021-01-13Merge remote-tracking branch 'remotes/origin/develop' into ↵Ivan Tashkinov
feature/object-hashtags-rework
2021-01-13[#3213] Prototype of data migrations functionality / HashtagsTableMigrator.Ivan Tashkinov
2021-01-13Bump Copyright to 2021Haelwenn (lanodan) Monnier
grep -rl '# Copyright © .* Pleroma' * | xargs sed -i 's;Copyright © .* Pleroma .*;Copyright © 2017-2021 Pleroma Authors <https://pleroma.social/>;'
2021-01-10[#3213] transfer_hashtags mix task refactoring.Ivan Tashkinov
2021-01-07[#3213] Removed PK from hashtags_objects table. Improved hashtags_transfer ↵Ivan Tashkinov
mix task (logging of failed ids).
2020-12-31[#3213] Added query options support for Repo.chunk_stream/4.Ivan Tashkinov
Used infinite timeout in transfer_hashtags select query.
2020-12-30[#3213] Improved `database.transfer_hashtags` mix task: proper rollback, ↵Ivan Tashkinov
speedup.
2020-12-28Revert "Merge branch 'features/hashtag-column' into 'develop'"Haelwenn
This reverts merge request !2824
2020-12-28pleroma.database fill_old_hashtags: Add month_limit argumentHaelwenn (lanodan) Monnier
2020-12-26[#3213] Hashtag-filtering functions in ActivityPub. Mix task for migrating ↵Ivan Tashkinov
hashtags to `hashtags` table.
2020-12-22Insert text representation of hashtags into object["hashtags"]Haelwenn (lanodan) Monnier
Includes a new mix task: pleroma.database fill_old_hashtags
2020-12-14Fix for dropping posts/notifs in WS when mix task is executedAlexander Strizhakov
- start oban in mix tasks with empty queues, plugins and crontab - fix for update_users_following_followers_counts - fix for removed logo.png - typo in resend confirmation emails mix task docs - fix for uploads mix task (start Majic.Pool) - fix for creating user mix task (start :fast_html app)
2020-09-16RepoStreamer.chunk_stream -> Repo.chunk_streamMaksim Pechnikov
2020-09-10remove validate_expires_at from enqueue methodAlexander Strizhakov
2020-09-10schedule activity expiration in ObanAlexander Strizhakov
2020-08-12reverting pinned posts in filteringAlexander Strizhakov
2020-08-12don't load pinned activities in due_expirationsAlexander Strizhakov
2020-08-12don't expire pinned postsAlexander Strizhakov
2020-08-11Ensure only Note objects are set to expireMark Felder
2020-08-08Ensure we only expire Create activities with the Mix taskMark Felder
2020-08-08Add mix task to add expiration to all local statusesEgor Kislitsyn
2020-05-27Alpha sortMark Felder
2020-05-27Abstract out the database maintenance. I'd like to use this from AdminFE too.Mark Felder
2020-05-27Make clearer that this is time and resource consumingMark Felder
2020-05-27Make it obvious a full vacuum can take a whileMark Felder
2020-05-27Permit easy access to vaccum full and analyze via a mix taskMark Felder
2020-03-03Update CopyrightsMark Felder
2019-10-21Merge branch 'develop' into refactor/following-relationshipsEgor Kislitsyn
2019-10-18Fix a migration wiping user info of users that don't have any mutesrinpatch
And introduce safe_jsonb_set
2019-10-11Replace `user.following` with Pleroma.FollowingRelationshipEgor Kislitsyn
2019-10-03Mix tasks: derive moduledoc from doc filesrinpatch
2019-10-03Move database maintenance tasks docs to a separate filerinpatch
2019-09-18Bump copyright years of files changed in 2019Haelwenn (lanodan) Monnier
Done via the following command: git diff 1e6c102bfcfe0e4835a48f2483f2376f9bf86a20 --stat --name-only | cat - | xargs sed -i 's/2017-2018 Pleroma Authors/2017-2019 Pleroma Authors/'
2019-08-10Strip internal fields including likes from incoming and outgoing activitiesSergey Suprunenko
2019-07-29constants: add as_public constant and use it everywhereAriadne Conill
2019-06-20Rename Pleroma.Mix.Tasks.Common -> Mix.Pleroma and import it's functionsrinpatch
instead of aliasing This seems to be the convention for functions that can be reused between different mix tasks in all Elixir projects I've seen and it gets rid on an error message when someone runs mix pleroma.common Also in this commit by accident: - Move benchmark task under a proper namespace - Insert a space after the prompt
2019-05-22Disable timeouts for object pruning queryrinpatch
2019-05-22prune objects task: use Repo.delete_all()William Pitcock
2019-05-21add mix task to prune the object database using a configured retention periodWilliam Pitcock
generated by cgit v1.2.3 (git 2.26.2) at 2025-04-23 10:28:30 +0000