matrix07012 @matrix@gameliberty.club

@matrix

A dang week to build that activity visibility index. Again, pretty dang beefy box (24 cores/2x12, 32GB RAM, hardware RAID, etc.) with almost no load on it, real hardware rather than a VM.

On my desktop machine, the same dump took 12 hours to load. Like, literally 1/15th the time. Main difference is Postgres 12 instead of 9, which is a little baffling because 12 *should* be faster. Here's a screenshot of the time required, with units output overlaid, plus the previous screenshot of my extreme exasperation.

I think what I'm gonna do is just skip that index when loading (by means of grep -v) for local dev stuff and use the internal PG format for dumps so that everything can get loaded piecemeal, and for the big migration, see I can trick it into working in parallel. I haven't read the migrations for current Pleroma, I figure that index might have been changed by now (or I hope so), but in any case, this one's gonna require some thought.
180:32:29.png
this_index_pushing_6_days.png

Ah, so the FSF elected an SJW as President.

https://www.phoronix.com/scan.php?page=news_item&px=FSF-President-2020

So..

“The FSF Board chose me at this moment as a servant leader to help the community focus on our shared dedication to protect and grow software that respects our freedoms. It is also important to protect and grow the diverse membership of the community. It is through our diversity of backgrounds and opinions that we have creativity, perspective, intellectual strength, and rigor…It requires renewed focus to achieve our goals. We must remember what unites us and why we came to free software in the first place. What inspired us in the past? What will keep us inspired, and what will inspire new generations of free software developers? We must be kind to each other and respect each other when our good faith arguments differ, in order to produce the best solutions together. I pledge to support honest dialog and emerging leaders in the quest to secure the future for free software for generations to come, and not to alter the tenets of the free software vision.”

out.png