In Warhol’s autobiography, there’s a scene where his friend has locked herself in the bathroom to recopy her address book. This is such a romantic notion to me—that over time, additions to the book would end up out of order, and one would periodically review and rewrite each entry. It would be an opportunity to think about everyone you know, and the result—the alphabetized book—would be both satisfying and useful.
In order to perform Pleroma’s flakeID update, I had to upgrade my postgres database from 9.5 to something newer. I picked 10.6 because that’s what came with Ubuntu 18.04. I used pg_upgrade which worked, but performance seemed slow. I noticed that I am not alone. I was not scientific about my efforts, so I don’t know which of these two commands solved my problem, but I ran: vacuumdb -d pleroma_dev –full