Profile directory About Mobile apps
Log in Sign up
Jul 8, 2022
matrix07012 :thotpatrol: @matrix@gameliberty.club

DB operations on harddrives are soooo fucking slow :pepeDread:

1
Jul 8, 2022
matrix07012 :thotpatrol: @matrix@gameliberty.club

>30 min
>1/6 of rows retrieved
>that's only the first step

1
Jul 8, 2022
matrix07012 :thotpatrol: @matrix@gameliberty.club

I misread, it was 1/60 :pepeGlasses:
Now it's at 1/10 after 2 and half hours :pepeDread:

1
Jul 8, 2022
matrix07012 :thotpatrol: @matrix@gameliberty.club

Now it's 1/6

1+
Jul 8, 2022
Electric Pants :prince_dance: @sjw@bae.st
@matrix what DB? What kind of HDD? How many? What configuration?
1
matrix07012 :thotpatrol: @matrix@gameliberty.club
Follow

@sjw I'm shrinking the Synapse DB and I had to move it from the SSD to the HDD because it doesn't have space for the temporary files.
https://levans.fr/shrink-synapse-database.html

Compressing Synapse database | Levans' workshop

Anyone running a federating instance of the Matrix homeserver Synapse will likely have seen this: synapse is database-hungry. It tends to take a lot of space. In…

levans.fr
July 8, 2022 at 2:34 PM · · Web · 0 · 0 · 0
Sign in to participate in the conversation
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.

Trending now

#emacs16 people talking
18
#特に理由はないですがこのハッシュタグつけてなにか投稿してくれませんか10 people talking
11
#wildlifephotography7 people talking
7

Resources

  • Terms of service
  • Privacy policy

Developers

  • Documentation
  • API

What is Mastodon?

gameliberty.club

  • About
  • v3.5.19

More…

  • Source code
  • Mobile apps
v3.5.19 · Privacy policy