Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Cyborg)
  • No Skin
Collapse
Brand Logo

CIRCLE WITH A DOT

  1. Home
  2. Uncategorized
  3. Maybe someone who knows more about #federation might be able to help me here: So my single-user #Pixelfed instance is sitting on a 20GB PSQL database after just one year.

Maybe someone who knows more about #federation might be able to help me here: So my single-user #Pixelfed instance is sitting on a 20GB PSQL database after just one year.

Scheduled Pinned Locked Moved Uncategorized
federationpixelfed
2 Posts 2 Posters 0 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • grosser_mensch@norden.socialG This user is from outside of this forum
    grosser_mensch@norden.socialG This user is from outside of this forum
    grosser_mensch@norden.social
    wrote last edited by
    #1

    Maybe someone who knows more about #federation might be able to help me here: So my single-user #Pixelfed instance is sitting on a 20GB PSQL database after just one year. Is there any way to make this more viable in the long term, like getting rid of old post info I got like 1 year ago from other servers? Or any other way to improve the storage efficiency here? It just feels weird that the database is using up more storage at this point then the image files saved on this instance…

    dansup@mastodon.socialD 1 Reply Last reply
    0
    • grosser_mensch@norden.socialG grosser_mensch@norden.social

      Maybe someone who knows more about #federation might be able to help me here: So my single-user #Pixelfed instance is sitting on a 20GB PSQL database after just one year. Is there any way to make this more viable in the long term, like getting rid of old post info I got like 1 year ago from other servers? Or any other way to improve the storage efficiency here? It just feels weird that the database is using up more storage at this point then the image files saved on this instance…

      dansup@mastodon.socialD This user is from outside of this forum
      dansup@mastodon.socialD This user is from outside of this forum
      dansup@mastodon.social
      wrote last edited by
      #2

      @grosser_mensch I am working on a new command you can run to clear out remote activities easily, and you will be able to automate this with a custom window of X days (ie: remove remote posts older than X days that I haven't interacted with)

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups