| 16 Aug 2021 |
 nixinator | ah. | 16:39:17 |
| nixinator | what is the synapse db? | 16:39:32 |
 andi- | A database :D | 16:39:47 |
| nixinator | ask a silly question.... | 16:40:02 |
| nixinator | :) | 16:40:06 |
| nixinator | get a well thought answer. :-) | 16:40:14 |
| andi- | Is postgresql the answer you were looking for? | 16:40:35 |
| nixinator | apparenty there is a script to do this. | 16:40:48 |
| nixinator | my friends a bit of pro matrix hoster. | 16:40:55 |
| andi- | Yeah there are a bunch but they are not really complete. | 16:41:04 |
| andi- | There is purging of empty rooms etc.. | 16:41:14 |
| nixinator | https://levans.fr/shrink-synapse-database.html | 16:43:44 |
| nixinator | i just asked him about this, and he had a meltdown about how crufty the db gets with matrix | 16:44:14 |
| nixinator | and how slow it can become. | 16:44:19 |
| nixinator | storage is the problem!!!! :-) too much state! :-) | 16:44:32 |
| andi- | So, it is a bit different with this server than with the usual homeserver. As this server is also serving logs for all the NixOS channels I can't just go ahead and purge history that is old. | 16:49:27 |
| andi- | Also purging the history of channels with no members (what happens on room version upgrades?) might not be a good idea for archiving purposes. | 16:49:58 |
| nixinator | sure....... | 16:51:21 |
| nixinator | well thanks for your services! | 16:51:31 |
| nixinator | much appeciated. | 16:51:36 |
| nixinator | where are the logs for the nixos channels, i used to use samualsdr's ones... | 16:52:13 |
| nixinator | but they were only for irc. | 16:52:23 |
| nixinator | we need to bring (^-^) back!! :-) | 16:52:34 |
| andi- | on https://nixos.dev/ you can find a list of channels that it provides logs for. The list is incomplete as I have to manually update it.. | 16:53:57 |
| andi- invited  stigo. | 16:56:33 |
| nixinator | nixos.dev, nice piece of code. | 16:59:26 |
| 21 Aug 2021 |
| andi- | I'll do some state compaction work on the server tonight. Usually that shouldn't impact anything but who knows... | 18:11:09 |
| andi- | Also while at it I'll switch the memory allocator from jemalloc to mimalloc. Have been testing that on my private server for a few weeks now. For both borg backups and synapse. Really seems to help with the memory spikes that happen when you join larger channels. | 18:38:07 |
| andi- | The promise of that tool was to compress data...
Number of rows after compression: 847 (123.11%)
| 19:14:48 |
| andi- | on the other extreme:
Number of rows after compression: 944793 (20.07%)
| 19:15:36 |
