nothing like the smell of ‘having to do emergency database maintenance because everything is fucked’ in the morning

73Gb in the new temporary location.. now VACUUM and move it all back..

holy shit was it worth it though

state_groups_state from:
2.80 * 10^8 row count, 42GB (table) + 22GB (index) = 64GB

to:
3.36 * 10*7 row count, 15GB (table) + 7208MB (index) = 15GB (wtf)

now just altering TABLESPACE to move it back to the same RAID1 disk

lets hope it all still works after 😬 😬 😬

Sign in to participate in the conversation
Pixietown

Small server part of the pixie.town infrastructure. Registration is closed.