GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Conversation

Notices

  1. Embed this notice
    Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 19:14:29 JST Sexy Moon Sexy Moon
    • iceloops 🚬 :love_forever_cat:
    • Moffin'tosh
    • Poppy (Back from tha dead) :neofox_flag_trans:
    @1iceloops123 @moffintosh @radmin around 640GB
    In conversation about a year ago from shitposter.club permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 19:20:02 JST Sexy Moon Sexy Moon
      in reply to
      • Neko McCatface v2023 :verified::makemeneko:
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @roboneko @moffintosh @radmin @1iceloops123 I mentioned that upthread that I know it shouldn't be that way so I don't have an explanation for it.
      In conversation about a year ago permalink
    • Embed this notice
      Neko McCatface v2023 :verified::makemeneko: (roboneko@bae.st)'s status on Tuesday, 19-Mar-2024 19:20:03 JST Neko McCatface v2023 :verified::makemeneko: Neko McCatface v2023 :verified::makemeneko:
      in reply to
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @Moon @moffintosh @radmin @1iceloops123 out of curiosity I assume the entire thing is on nvme? it's weird because postgres gets used at _much_ larger sizes so you've got to wonder WTF is causing it
      In conversation about a year ago permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 19:56:53 JST Sexy Moon Sexy Moon
      in reply to
      • Neko McCatface v2023 :verified::makemeneko:
      • iceloops 🚬 :love_forever_cat:
      • :blank:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @i @roboneko @moffintosh @radmin @1iceloops123 I understand why it takes so much space, I don't understand why it slows down.
      In conversation about a year ago permalink
    • Embed this notice
      :blank: (i@declin.eu)'s status on Tuesday, 19-Mar-2024 19:56:55 JST :blank: :blank:
      in reply to
      • Neko McCatface v2023 :verified::makemeneko:
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @roboneko @moffintosh @radmin @1iceloops123 @Moon it's just a complete mess of an implementation on the pleroma side, 30gb of activities needs 24gb of indexing, 20gb of objects needs 9gb of indexing (on this instance), not to mention all the wonky pgplsql functions making even fundamental things like the home timeline non deterministic

      no one cares enough anymore fix any of this mess, and maybe that's for the better
      In conversation about a year ago permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 20:04:02 JST Sexy Moon Sexy Moon
      in reply to
      • anime graf mays ?️?
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @graf @moffintosh @radmin @1iceloops123 I wrote that confusingly. they are two separate problems. someone was raping my server, every core was 100% PostgreSQL. This is while Pleroma itself is on a separate box still.
      In conversation about a year ago permalink
    • Embed this notice
      anime graf mays ?️? (graf@poa.st)'s status on Tuesday, 19-Mar-2024 20:04:03 JST anime graf mays ?️? anime graf mays ?️?
      in reply to
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @Moon @1iceloops123 @moffintosh @radmin ours is over 600GB and we don’t have this problem. i dont think it’s scraping as much as the rot meme. the added load might slow it down but it’s not the root cause
      In conversation about a year ago permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 20:05:48 JST Sexy Moon Sexy Moon
      in reply to
      • anime graf mays ?️?
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @graf @moffintosh @radmin @1iceloops123 I don't like calling it rot but I admit it's a semantic distinction. I have worked with databases that are much larger than Pleroma's and don't have this slowdown problem. People keep saying "it's because JSON" but that just doesn't make any sense. I personally have a bigger DB than SPC at work that uses JSONB
      In conversation about a year ago permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 20:06:24 JST Sexy Moon Sexy Moon
      in reply to
      • Neko McCatface v2023 :verified::makemeneko:
      • feld
      • iceloops 🚬 :love_forever_cat:
      • :blank:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @feld @roboneko @i @moffintosh @radmin @1iceloops123 you're a three user instance.
      In conversation about a year ago permalink
    • Embed this notice
      feld (feld@bikeshed.party)'s status on Tuesday, 19-Mar-2024 20:06:25 JST feld feld
      in reply to
      • Neko McCatface v2023 :verified::makemeneko:
      • iceloops 🚬 :love_forever_cat:
      • :blank:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @i @roboneko @moffintosh @radmin @1iceloops123 @Moon

      > no one cares enough anymore fix any of this mess, and maybe that's for the better

      I've never experienced any of the weirdness SPC reports, personally, so it's hard to fix what you can't reproduce
      In conversation about a year ago permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 20:09:25 JST Sexy Moon Sexy Moon
      in reply to
      • Neko McCatface v2023 :verified::makemeneko:
      • feld
      • Birdulon
      • iceloops 🚬 :love_forever_cat:
      • :blank:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @birdulon @roboneko @feld @i @moffintosh @radmin @1iceloops123 There are also cases yeah where in bursts it is painfully slow for no reason.
      In conversation about a year ago permalink
    • Embed this notice
      Birdulon (birdulon@shpposter.club)'s status on Tuesday, 19-Mar-2024 20:09:27 JST Birdulon Birdulon
      in reply to
      • Neko McCatface v2023 :verified::makemeneko:
      • feld
      • iceloops 🚬 :love_forever_cat:
      • :blank:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @Moon @roboneko @feld @i @moffintosh @radmin @1iceloops123 funnily enough this instance is similarly small yet sees awful performance issues from time to time
      In conversation about a year ago permalink
    • Embed this notice
      ?? Humpleupagus ?? (humpleupagus@eveningzoo.club)'s status on Tuesday, 19-Mar-2024 20:18:28 JST ?? Humpleupagus ?? ?? Humpleupagus ??
      in reply to
      • anime graf mays ?️?
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      Do you mind sharing how you're trimming the database? I've found that the activities table is the biggest beast.
      In conversation about a year ago permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 20:21:51 JST Sexy Moon Sexy Moon
      in reply to
      • anime graf mays ?️?
      • ?? Humpleupagus ??
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @Humpleupagus @moffintosh @radmin @graf @1iceloops123 I'm going to do a series of delete queries. Then when I am done I am going to do a full backup and then full restore.
      In conversation about a year ago permalink
    • Embed this notice
      Sexy Moon (moon@shitposter.club)'s status on Tuesday, 19-Mar-2024 20:23:57 JST Sexy Moon Sexy Moon
      in reply to
      • anime graf mays ?️?
      • ?? Humpleupagus ??
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      @Humpleupagus @1iceloops123 @graf @moffintosh @radmin if you don't do a delete and restore, it won't let go of the space.
      In conversation about a year ago permalink
    • Embed this notice
      ?? Humpleupagus ?? (humpleupagus@eveningzoo.club)'s status on Tuesday, 19-Mar-2024 20:30:21 JST ?? Humpleupagus ?? ?? Humpleupagus ??
      in reply to
      • anime graf mays ?️?
      • iceloops 🚬 :love_forever_cat:
      • Moffin'tosh
      • Poppy (Back from tha dead) :neofox_flag_trans:
      You can vacuum full, but you need enough space for the rebuilt db. That'll take a while given the size of your database.

      You may be able to partition the tables based on date and then drop the partitions you don't want. That should be nearly instant. I wouldn't try this without a backup or without knowing exactly what you're doing. Often when I'm planning on doing something I'm not sure of in a live environment, I'll set up a test environment on a separate system so I fuck that up trying to figure out the correct process instead of the live server.
      In conversation about a year ago permalink
      Sexy Moon likes this.

Feeds

  • Activity Streams
  • RSS 2.0
  • Atom
  • Help
  • About
  • FAQ
  • TOS
  • Privacy
  • Source
  • Version
  • Contact

GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.