anime graf mays 🛰️🪐 on Nostr: GroundBeefHunter yessir im compressing room states. some rooms (matrixHQ for example) ...
GroundBeefHunter (npub1n8q…3d6h) yessir im compressing room states. some rooms (matrixHQ for example) are over 100GB on-disk for postgresql. thats fucking crazy
i started doing it last night and we've gone from 420GB on disk to about 390GB. hoping to get it down to about 100GB
Published at
2023-05-04 18:58:11Event JSON
{
"id": "94095e4fb207f0b31c75730b1d556c8edbfd122c2b353a23af9ad3f9a9c694c6",
"pubkey": "79c4b3e2b1e7d8d74fa652cdc1dee37f9cd08fefdc13a79f8d1146c0b69fd1fb",
"created_at": 1683226691,
"kind": 1,
"tags": [
[
"p",
"99c1e5d0d851f980d35718c36aa6ebf6da20fda57e92b5a4c6342a52de492adb",
"wss://relay.mostr.pub"
],
[
"e",
"17d798ce459aaf2f4fbb700371998570f672ae1ad0dbbdd166a5ce01d5ed6fa9",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://poa.st/objects/966f77f2-3fa3-41ce-83e1-39cb4220fd4e"
]
],
"content": "nostr:npub1n8q7t5xc28ucp56hrrpk4fht7mdzpld906fttfxxxs499hjf9tds4s3d6h yessir im compressing room states. some rooms (matrixHQ for example) are over 100GB on-disk for postgresql. thats fucking crazy\n\ni started doing it last night and we've gone from 420GB on disk to about 390GB. hoping to get it down to about 100GB",
"sig": "04f5a029a9337dcb586ea60bd30b9437f852d15068d423fb68dddfedeb9ff05d1074d37653869be2bd9647af3c6aa4430f7c6e563326002763038a013742e5c2"
}
