| 7 Aug 2021 |
 andi- | https://status.hetzner.com/incident/0ba5eb38-d70c-4f53-a5c8-07984074ec6d | 13:53:17 |
|  Nikolay Korotkiy joined the room. | 21:45:55 |
| 12 Aug 2021 |
|  dusk changed their profile picture. | 22:23:36 |
| 15 Aug 2021 |
| dusk changed their profile picture. | 03:21:22 |
| 16 Aug 2021 |
| andi- | 
Download Screenshot 2021-08-16 at 18.35.03.png | 16:35:22 |
| andi- | Time to investigate how state compaction works. | 16:35:28 |
 nixinator | state compaction? | 16:37:53 |
| nixinator | sounds intresting. | 16:38:04 |
| nixinator | zfs? | 16:38:22 |
| andi- | no, on protocol level | 16:38:32 |
| andi- | or database level | 16:38:35 |
| andi- | there is some stuff around reducing chatter that is stored in the DB. It basically stores every single join/leave event (and more) and that can supposedly be reduced. | 16:39:07 |
| 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 |
