From 638f023a1c03a17881be76e8a3de3ceda417393d Mon Sep 17 00:00:00 2001 From: tobi <31960611+tsmethurst@users.noreply.github.com> Date: Mon, 21 Aug 2023 15:03:04 +0200 Subject: [performance] Tweak media attachment cleanup; replace stale index (#2143) --- internal/db/media.go | 20 -------------------- 1 file changed, 20 deletions(-) (limited to 'internal/db/media.go') diff --git a/internal/db/media.go b/internal/db/media.go index 94a365c26..0ef03226b 100644 --- a/internal/db/media.go +++ b/internal/db/media.go @@ -50,24 +50,4 @@ type Media interface { // GetCachedAttachmentsOlderThan gets limit n remote attachments (including avatars and headers) older than // the given time. These will be returned in order of attachment.created_at descending (i.e. newest to oldest). GetCachedAttachmentsOlderThan(ctx context.Context, olderThan time.Time, limit int) ([]*gtsmodel.MediaAttachment, error) - - // CountRemoteOlderThan is like GetRemoteOlderThan, except instead of getting limit n attachments, - // it just counts how many remote attachments in the database (including avatars and headers) meet - // the olderThan criteria. - CountRemoteOlderThan(ctx context.Context, olderThan time.Time) (int, error) - - // GetAvatarsAndHeaders fetches limit n avatars and headers with an id < maxID. These headers - // and avis may be in use or not; the caller should check this if it's important. - GetAvatarsAndHeaders(ctx context.Context, maxID string, limit int) ([]*gtsmodel.MediaAttachment, error) - - // GetLocalUnattachedOlderThan fetches limit n local media attachments (including avatars and headers), older than - // the given time, which aren't header or avatars, and aren't attached to a status. In other words, attachments which were - // uploaded but never used for whatever reason, or attachments that were attached to a status which was subsequently deleted. - // - // These will be returned in order of attachment.created_at descending (newest to oldest in other words). - GetLocalUnattachedOlderThan(ctx context.Context, olderThan time.Time, limit int) ([]*gtsmodel.MediaAttachment, error) - - // CountLocalUnattachedOlderThan is like GetLocalUnattachedOlderThan, except instead of getting limit n attachments, - // it just counts how many local attachments in the database meet the olderThan criteria. - CountLocalUnattachedOlderThan(ctx context.Context, olderThan time.Time) (int, error) } -- cgit v1.2.3