I'm tempted to do one last experiment on the faulty server I intend to cancel, by re-ordering the columns on Mastodon's schema and then using logical replication, to see the difference in disk space used.

Show thread
Follow

Alright, I did a very cumbersome experiment on the accounts table, because it's got a lot of columns of different types and not so many rows that it would take long to copy data.

Original size: 2498 MB. Size when columns are re-ordered: 2443 MB. So that's like 2.2% savings (55MB).

Of course, every table is different. Maybe you could squeeze more out of the statuses table, which is so much larger. But I'm not sure it's worth the effort...

· · Web · 1 · 1 · 6
Sign in to participate in the conversation
Mastodon

Server run by the main developers of the project 🐘 It is not focused on any particular niche interest - everyone is welcome as long as you follow our code of conduct!