Conversation

Notices

1. Embed this notice
   Futurist Jim Carroll (jimcarroll@futurist.info)'s status on Sunday, 03-Nov-2024 23:20:32 JST Futurist Jim Carroll

   How did I not know about the magic of "pg_repack -d mastodon_production"

   !

   #selfhost #mastoadmin #selfhosting

   • Embed this notice
     Mark Stosberg (markstos@urbanists.social)'s status on Monday, 04-Nov-2024 01:04:38 JST Mark Stosberg

     in reply to

     @jimcarroll Adding context:

     "pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance comparable to using CLUSTER directly."

     https://reorg.github.io/pg_repack/

   • Embed this notice
     Futurist Jim Carroll (jimcarroll@futurist.info)'s status on Monday, 04-Nov-2024 01:14:54 JST Futurist Jim Carroll

     in reply to

     • Mark Stosberg

     @markstos Thanks for putting some context on my post! Saved 6GB on my 40GB self-host server!

   • Embed this notice
     Futurist Jim Carroll (jimcarroll@futurist.info)'s status on Monday, 04-Nov-2024 04:12:43 JST Futurist Jim Carroll

     in reply to

     • Michael

     @michael Carefully checked that out with the docs before I started. Also made a snapshot backup before. And have a full server backup always available. Have had lots of booms before.

     This from @michael was an excellent guide.

     https://blog.thms.uk/2024/01/pg-repack-mastodon

     #mastoadmin #selfhost #selfhosting

   • Embed this notice
     Michael (michael@mstdn.thms.uk)'s status on Monday, 04-Nov-2024 04:12:45 JST Michael

     in reply to

     @jimcarroll gotta be careful with this: if you don’t have enough free disk space it’ll go kaboom 💥