Conversation

Notices

1. Mr. Bacon (tony@clew.lol)'s status on Saturday, 30-Dec-2023 03:03:13 JST Mr. Bacon
   Should I delete some tables in a production environment?
   
   Idk shit about databases
   
   #risktaker
   • Machismo repeated this.
   • Mr. Bacon (tony@clew.lol)'s status on Saturday, 30-Dec-2023 03:19:33 JST Mr. Bacon

     in reply to

     • スカイラー🎄🇷🇺 :z:
     Yah, just crashed the server so apparently deleting rows isn't the way.
     
     Thank god it exited without corrupting anything.
   • Mr. Bacon (tony@clew.lol)'s status on Saturday, 30-Dec-2023 03:19:34 JST Mr. Bacon

     in reply to

     • スカイラー🎄🇷🇺 :z:
     That's what I'm trying to do. I know I can't delete the entire table, so I found the table with the post data, so I was planning to delete posts older than 90 days or something like that.
     
     I'm checking table data right now though to make sure I don't screw something up lol
     Machismo repeated this.
   • スカイラー🎄🇷🇺 :z: (skylar@misskey.yandere.love)'s status on Saturday, 30-Dec-2023 03:19:35 JST スカイラー🎄🇷🇺 :z:

     in reply to
     @Tony oh don't do that, it won't know to recreate the tables and it'll just crash
     you can try vacuuming the DB to clear some stuff up
     pg_repack helps but can't be used when the disk is nearly full
     i haven't really looked at a way to purge old posts yet but it's probably just deleting records from the activities table based on timestamp
     Machismo repeated this.
   • Mr. Bacon (tony@clew.lol)'s status on Saturday, 30-Dec-2023 03:19:36 JST Mr. Bacon

     in reply to

     • スカイラー🎄🇷🇺 :z:
     My disk space is full so I'm trying to clear out some of my old posts to free up space.
     Machismo repeated this.
   • スカイラー🎄🇷🇺 :z: (skylar@misskey.yandere.love)'s status on Saturday, 30-Dec-2023 03:19:37 JST スカイラー🎄🇷🇺 :z:

     in reply to
     @Tony only if they're worthless tables
   • Precious (timespent@poa.st)'s status on Saturday, 30-Dec-2023 03:19:45 JST Precious

     in reply to
     @Tony >Is everything working?
     Well, yes
     >Maybe we should fix that
     :jahy_evil:
   • Machismo (zerglingman@freespeechextremist.com)'s status on Saturday, 30-Dec-2023 03:22:09 JST Machismo

     in reply to

     • スカイラー🎄🇷🇺 :z:
     @Tony @skylar Isn't the media folder a better target?
   • Machismo (zerglingman@freespeechextremist.com)'s status on Saturday, 30-Dec-2023 03:23:57 JST Machismo

     in reply to

     • Machismo
     • スカイラー🎄🇷🇺 :z:
     @skylar @Tony (*Also when deleting posts, make sure to not delete local posts, only remote?)
   • Mr. Bacon (tony@clew.lol)'s status on Saturday, 30-Dec-2023 03:24:07 JST Mr. Bacon

     in reply to

     • Machismo
     • スカイラー🎄🇷🇺 :z:
     I cleared old logs and freed up around 200mb - I couldn't find the "media folder". I have 40g diskspace and found like 28g of it is in the db datatables so I figured that was the place to go.
   • Machismo (zerglingman@freespeechextremist.com)'s status on Saturday, 30-Dec-2023 03:24:31 JST Machismo

     in reply to

     • スカイラー🎄🇷🇺 :z:
     @Tony @skylar oh geeze ok, fair enough.
   • Machismo (zerglingman@freespeechextremist.com)'s status on Saturday, 30-Dec-2023 03:25:15 JST Machismo

     in reply to

     • Machismo
     • スカイラー🎄🇷🇺 :z:
     @skylar @Tony ... Though IIRC there's a way to make postgres spit out the (approximate?) size of each table so that's probably worth doing. I find it hard to believe you have ~25gb of posts.
   • Mr. Bacon (tony@clew.lol)'s status on Saturday, 30-Dec-2023 03:25:27 JST Mr. Bacon

     in reply to

     • Machismo
     • スカイラー🎄🇷🇺 :z:
     idk, I haven't taken the time to really dig into this yet. I've been working on other stuff to build my software knowledge because when I first set up the server this was way over my head.
     
     But now, it seems the options are either learn more about pleroma or migrate my VPS to one with more disk space lol.
   • Machismo (zerglingman@freespeechextremist.com)'s status on Saturday, 30-Dec-2023 03:26:24 JST Machismo

     in reply to

     • スカイラー🎄🇷🇺 :z:
     @Tony @skylar Pleroma does come with some sort of cleanup function that I don't remember, look in pleromactl --help, I think it's there. Vacuum or something. It seems to work pretty well. I should probably hit mine with it again soon, actually.
   • スカイラー🎄🇷🇺 :z: (skylar@misskey.yandere.love)'s status on Saturday, 30-Dec-2023 03:46:50 JST スカイラー🎄🇷🇺 :z:

     in reply to

     • Machismo
     @Zerglingman @Tony i find it easy to believe
     mine's >40GB
     no idea what's in there, but posts and such are the only thing that goes in the database
     Machismo likes this.
   • Mr. Bacon (tony@clew.lol)'s status on Saturday, 30-Dec-2023 03:56:57 JST Mr. Bacon

     in reply to

     • Machismo
     • スカイラー🎄🇷🇺 :z:
     30k posts and only like 4gs are text but 15gs are media. That’s where it really adds up quick
     Machismo likes this.
   • Machismo (zerglingman@freespeechextremist.com)'s status on Saturday, 30-Dec-2023 03:57:17 JST Machismo

     in reply to

     • スカイラー🎄🇷🇺 :z:
     @Tony @skylar ... Is media stored in the DB?