Post ARaKHMuvBZ8CYYLzWK by sjw@bae.st
(DIR) More posts by sjw@bae.st
(DIR) Post #ARaG8mWQDbHLXsXnkW by sjw@bae.st
2023-01-13T00:39:49.334792Z
2 likes, 1 repeats
Okay so some time tonight or this weekend I'm going to try to do a `vacuum full` on the database . I didn't realise it had gotten so chonk. Hopefully it'll free up a good bit of space. #BigData #BaestNewsScreenshot_20230112-183451~2.png
(DIR) Post #ARaGUXS8vQPNBFuvrs by NEETzsche@iddqd.social
2023-01-13T00:43:52.067267Z
2 likes, 0 repeats
You got me beat five fold. Mine is at about 106GB. I did vacuum mine a while ago and that did reduce it a lot. But I’m also on Rebased, and something @alex wrote ostensibly reduced the DB size quite significantly.
(DIR) Post #ARaICPpUjJIkEVKGZs by sjw@bae.st
2023-01-13T01:02:58.322948Z
2 likes, 0 repeats
@NEETzsche @alex oh interestingI'd love to hear what exactly he changedI've been meaning to switch to rebased
(DIR) Post #ARaKHMuvBZ8CYYLzWK by sjw@bae.st
2023-01-13T01:26:19.072606Z
0 likes, 0 repeats
@NEETzsche @alex What exactly is the process to migrate to rebased?
(DIR) Post #ARabTuO0GxiD3RWPnk by sjw@bae.st
2023-01-13T03:13:30.530240Z
0 likes, 0 repeats
@NEETzsche the database must get bigger before it can get smaller#BaestNews #BigDataScreenshot_20230112-211137~2.png
(DIR) Post #ARabTzWLBOLsykSdzU by sjw@bae.st
2023-01-13T04:38:51.467830Z
1 likes, 1 repeats
@NEETzsche well this isn't looking super promising.The size of the repacked activities table is the same size as the original (indexes are still being built).Is this just how big my database is now? I need to hurry up and invest in dedicated drives just for postgres. I'm thinking 4 500 GB Crucial P2 M.2 SSDs in RAID-Z with a hotspare or two. Total cost of the upgrade would be around $300 which sadly is money I don't really have right now. I have an eye exam coming up in February which will cost around $50 (hopefully) plus contacts which will cost around $200. Hopefully we can manage until around the end of March when I can save up enough funds... #BaestNews #BigDataScreenshot_20230112-221201~2.png
(DIR) Post #ARacVFU9Paz4jhbH5U by NEETzsche@iddqd.social
2023-01-13T04:50:31.086970Z
1 likes, 0 repeats
Apparently this takes a while. Like, a long while. It took me a couple weeks, but I ran it extra super duper slow.
(DIR) Post #ARadZ2xc1LDl0Hktoe by sjw@bae.st
2023-01-13T05:02:24.994868Z
0 likes, 0 repeats
@NEETzsche I'm about halfway done.I'm using pg_repackhttps://reorg.github.io/pg_repack/
(DIR) Post #ARaoxjw8zD9Wjp2u4e by roboneko@masochi.st
2023-01-13T07:10:09.235167Z
0 likes, 0 repeats
:jahy_scared:
(DIR) Post #ARbg6dN43v4QYFlQ7k by sjw@bae.st
2023-01-13T06:09:01.052987Z
0 likes, 0 repeats
@NEETzsche I fear I won't have enough disk space to complete this...Screenshot_20230113-000529.png
(DIR) Post #ARbg6dvS04ZmGtqsim by sjw@bae.st
2023-01-13T17:05:34.812866Z
1 likes, 0 repeats
@NEETzsche @roboneko well it looks like the vacuum full freed up around 45 GB#BaestNewsScreenshot_20230113-110258~2.png
(DIR) Post #ARbg6f1rthIth5rWMa by sjw@bae.st
2023-01-13T06:11:41.963383Z
0 likes, 0 repeats
@NEETzsche I'm now down to only 40 GB free on /
(DIR) Post #ARbg6gzoaIqjnIuuRM by sjw@bae.st
2023-01-13T07:28:32.617446Z
1 likes, 0 repeats
@NEETzsche I made it with only around 9 GB of free space
(DIR) Post #ARbtpaCI0XvT8xUHc8 by sjw@bae.st
2023-01-13T07:56:24.608878Z
1 likes, 0 repeats
@roboneko @NEETzsche I got down to 9 GB (which made the filesystem perform like shit and take longer than it should have) but I made it.