Public
- Public
- Network
- Groups
- Popular
- People

Conversation

Notices

cassidyclown (cassidyclown@clubcyberia.co)'s status on Monday, 04-Sep-2023 16:54:51 JST cassidyclown
- Lina Inver:z:e :mur_close: :nuts:
@mint @lina how big are your databases + how many years have they been active? (curious)

In conversation about a year ago from clubcyberia.co permalink
- (mint@ryona.agency)'s status on Monday, 04-Sep-2023 16:54:50 JST
  in reply to
  - Lina Inver:z:e :mur_close: :nuts:
  @cassidyclown @lina 68.3 gigs on disk, 7 gigs as a gzip-compressed dump (too lazy to unpack).
  
  In conversation about a year ago permalink
- (mint@ryona.agency)'s status on Monday, 04-Sep-2023 17:00:04 JST
  in reply to
  - Lina Inver:z:e :mur_close: :nuts:
  @cassidyclown @lina About a year and a half, started in April '22.
  
  In conversation about a year ago permalink
- cassidyclown (cassidyclown@clubcyberia.co)'s status on Monday, 04-Sep-2023 17:00:05 JST cassidyclown
  in reply to
  - Lina Inver:z:e :mur_close: :nuts:
  @mint @lina oh damn that's pretty big then - how many years has ryona been up?
  
  In conversation about a year ago permalink
- cassidyclown (cassidyclown@clubcyberia.co)'s status on Monday, 04-Sep-2023 17:06:13 JST cassidyclown
  in reply to
  @iamtakingiteasy @lina @mint wtf I thought my instance was too fat now I learn it is not fat enough
  
  In conversation about a year ago permalink
  
  likes this.
- Yukkuri (iamtakingiteasy@eientei.org)'s status on Monday, 04-Sep-2023 17:06:14 JST Yukkuri
  in reply to
  - Lina Inver:z:e :mur_close: :nuts:
  @lina @cassidyclown @mint Currently pleroma DB is 130 gigs, with daily growth averaging at about 200+ megabytes. The size is also somewhat inflated by FTS indices. Have been running since February of 2021 for ~2+ years now and have survived domain migration.
  In conversation about a year ago permalink
  Attachments
  1. Untitled attachment
    https://eientei.org/media/c66aee01156a1557cef45947b1fa0d4372103957c12f938073789d965816ee2e.png?name=image.png
  2. Untitled attachment
    https://eientei.org/media/961dff7c1043a64eb66bd03f8388dfa441485691a54e54632ae70634f4ddc8ad.png?name=image.png
- Lina Inver:z:e :mur_close: :nuts: (lina@eientei.org)'s status on Monday, 04-Sep-2023 17:06:16 JST Lina Inver:z:e :mur_close: :nuts:
  in reply to
  - Yukkuri
  @cassidyclown @mint i do? i'm humbled, not gonna lie, but i just have fun on eientei
  cc @iamtakingiteasy
  
  In conversation about a year ago permalink
- cassidyclown (cassidyclown@clubcyberia.co)'s status on Monday, 04-Sep-2023 17:06:17 JST cassidyclown
  in reply to
  - Lina Inver:z:e :mur_close: :nuts:
  @lina @mint oshit I thought you were the admin sorry you have admin energy
  
  In conversation about a year ago permalink
- Lina Inver:z:e :mur_close: :nuts: (lina@eientei.org)'s status on Monday, 04-Sep-2023 17:06:18 JST Lina Inver:z:e :mur_close: :nuts:
  in reply to
  @cassidyclown @mint i dunno how big the database is or how long the instance has been running :ryukofuckedup:
  
  In conversation about a year ago permalink
- Lina Inver:z:e :mur_close: :nuts: (lina@eientei.org)'s status on Monday, 04-Sep-2023 17:12:17 JST Lina Inver:z:e :mur_close: :nuts:
  in reply to
  @cassidyclown @Zealous @iamtakingiteasy @mint i don't fucking know but it was funny putting "UOHHHHHHHH GAINER BULL BELLY EROTIC" instead of reimu's page
  
  In conversation about a year ago permalink
  
  likes this.
- cassidyclown (cassidyclown@clubcyberia.co)'s status on Monday, 04-Sep-2023 17:12:18 JST cassidyclown
  in reply to
  @lina @Zealous @iamtakingiteasy @mint holy shit how did he achieve that
  
  In conversation about a year ago permalink
- Lina Inver:z:e :mur_close: :nuts: (lina@eientei.org)'s status on Monday, 04-Sep-2023 17:12:19 JST Lina Inver:z:e :mur_close: :nuts:
  in reply to
  @Zealous @cassidyclown @iamtakingiteasy @mint gainer bull fedi instance
  i remember putting this up on the other touhou wiki when it was getting raided
  
  In conversation about a year ago permalink
- Zealous :verified: (zealous@clubcyberia.co)'s status on Monday, 04-Sep-2023 17:12:20 JST Zealous :verified:
  in reply to
  @cassidyclown @iamtakingiteasy @lina @mint feeder fetish
  
  In conversation about a year ago permalink
- 🐘🐘 Humpleupagus 🐘🐘 (humpleupagus@eveningzoo.club)'s status on Monday, 04-Sep-2023 17:32:04 JST 🐘🐘 Humpleupagus 🐘🐘
  in reply to
  Does the prune feature effect the result of the vacuum full? Rough math, would say pruning to 30 days vs. 90 days result in a database one-third the size after vacuum full.
  
  In conversation about a year ago permalink
- zero escape (zero@nightshift.social)'s status on Monday, 04-Sep-2023 17:32:04 JST zero escape
  in reply to
  i didnt specify a prune 30 or a prune 90 i just did the db vaccum.. (im sure i copy pasted it off graf) and the damn thing bought me enough space to give me time to figure out how i was going to up the storage.
  
  digital ocean bundles it... if i was smart i would have given storage its own mount point as thats cheaper to upgrade....
  
  add this to one of a hundred regrets i have experienced in my life
  
  In conversation about a year ago permalink
  
  Machismo repeated this.
- 🐘🐘 Humpleupagus 🐘🐘 (humpleupagus@eveningzoo.club)'s status on Monday, 04-Sep-2023 17:32:05 JST 🐘🐘 Humpleupagus 🐘🐘
  in reply to
  I'm about 100gb at a little over two years. I really want to strip it back to nothing, and let it grow for another two years. I was wondering how to do that though, e.g. trim the db down to a week of posts and vacuum full? Not sure that would work though.
  
  In conversation about a year ago permalink
- zero escape (zero@nightshift.social)'s status on Monday, 04-Sep-2023 17:32:05 JST zero escape
  in reply to
  The vacuum command got my db down from like 45gb to 15gb
  
  In conversation about a year ago permalink
- 🐘🐘 Humpleupagus 🐘🐘 (humpleupagus@eveningzoo.club)'s status on Monday, 04-Sep-2023 17:32:45 JST 🐘🐘 Humpleupagus 🐘🐘
  in reply to
  Can't you stop the server and database, rsync the postgres directory to a remote file system storage, rename the local postgres directory (temp backup just inv case), mount the remote file system at a directory with the same name/permissions as the original postgres directory, and turn it all back on?
  
  In conversation about a year ago permalink
- 🐘🐘 Humpleupagus 🐘🐘 (humpleupagus@eveningzoo.club)'s status on Monday, 04-Sep-2023 17:34:50 JST 🐘🐘 Humpleupagus 🐘🐘
  in reply to
  It's not a backup technically. It's an "oh shit. I can get this back up by just renaming a directory." Saves the need to dump. You can get the server up immediately after mount... I think. If it comes up, you can delete the renamed directory.
  
  In conversation about a year ago permalink
- † top dog :pedomustdie: (dcc@annihilation.social)'s status on Monday, 04-Sep-2023 17:34:51 JST † top dog :pedomustdie:
  in reply to
  @Humpleupagus @cassidyclown @iamtakingiteasy @lina @zero @mint If you want to back up a db, just dump it lol.
  
  In conversation about a year ago permalink
  
  Machismo repeated this.

Public

Conversation

Notices

Feeds