Teaching people to install an apk seems a lot simpler than getting them to fully switch ecosystems.
Some additional info for anyone who is dumb like me and wants to do this:
To do this, I first had to install pg_repack using the postgresql repo:
https://wiki.postgresql.org/wiki/Apt
Then I had to follow these instructions, including adding the extension to any of the databases I wanted to repack:
https://dbsguru.com/install-and-configure-pg_repack-in-postgresql/
I ended up just running pg_repack -a as the postgres user.
I chose to run it on my peertube and pleroma databases. Peertube was done in just a few minutes.
Note that it's a pretty serious operation. It seemed to take about 40 minutes on my relatively trivial instance, and it pegged an entire core at 100% the whole time, though the sites kept running while the operation occurred. Even with an SSD, I ended up with pretty high IOWait times during the repack because it was moving a lot of data around.
It seems to have brought my peak loads down quite a bit. The Pleroma task still can take up a whole lot of cpu power when there's lots of stuff going on, but the postgresql tasks basically idle now whereas they were significant beforehand.
To do this, I first had to install pg_repack using the postgresql repo:
https://wiki.postgresql.org/wiki/Apt
Then I had to follow these instructions, including adding the extension to any of the databases I wanted to repack:
https://dbsguru.com/install-and-configure-pg_repack-in-postgresql/
I ended up just running pg_repack -a as the postgres user.
I chose to run it on my peertube and pleroma databases. Peertube was done in just a few minutes.
Note that it's a pretty serious operation. It seemed to take about 40 minutes on my relatively trivial instance, and it pegged an entire core at 100% the whole time, though the sites kept running while the operation occurred. Even with an SSD, I ended up with pretty high IOWait times during the repack because it was moving a lot of data around.
It seems to have brought my peak loads down quite a bit. The Pleroma task still can take up a whole lot of cpu power when there's lots of stuff going on, but the postgresql tasks basically idle now whereas they were significant beforehand.
Can you believe these racist conspiracy theorists in (checks card) the major airlines?
Are bedframes a thing women want?
Because I'm an alpha chad in that department. I've got like four bedframes. Bitches hanging off my dick all day long!
Because I'm an alpha chad in that department. I've got like four bedframes. Bitches hanging off my dick all day long!
It's fooooine. Poor people don't heat their homes or eat food or take forms of transportation anywhere!
My son has a toy that works like this, and it's frickin hilarious.
The A, B, C, D, Circle, Triangle, Star and Square all fit in the square hole.
The A, B, C, D, Circle, Triangle, Star and Square all fit in the square hole.
The summer of love riots were a political stunt largely directed by the powers that be, but I suspect real riots with the productive members of society would be much more effective and wouldn't end up in poor neighborhoods tearing up what few possessions they have.
In that context, it should be obvious why they're stomping on the neck of anything they didn't orchestrate.
In that context, it should be obvious why they're stomping on the neck of anything they didn't orchestrate.
Our leadership is decadent, and so they don't realize there's a physical world that can't be ordered around. We need food, we need to keep our homes warm, we need a lot other things, and if we don't get those things then we start to die (and slightly before that riot en masse) and there's no order you can give to people not to die of starvation if there's no food.
I can't get past the fact that these people seem to forget they're on a platform that allowed calling for certain forms of genocide the whole time, and oh by the way FOUGHT IN COURT TO BE ABLE TO CONTINUE HOSTING CHILD PORN.
I'm well on the record of not liking Elon, but him buying Twitter so far has been a net positive for the human race.
I'm well on the record of not liking Elon, but him buying Twitter so far has been a net positive for the human race.
I was new to the city so I guess I get to swing because I don't have a bunch of friends to vouch for me...
Probably more than you'd think. My little server hosted on parts scavenged from a roadside sign claims to be connecting to 8251 peers. I would imagine that number would be quite a bit higher on a server with 1000 times the users.
If we can teach the upcoming generation that "Free" doesn't mean free, that'll be a good thing we've done.
Wow, you must have a seriously nice collection to be filling not just your local space, but such a large hard drive!
I can see both sides. On one hand, I had a lot of fun trying to figure out how to do everything in 640k back in the day, but on the other hand, being able to just use the memory you need and focus on solving the problems is nice sometimes as well.
I ended up putting all my movies in digital format using handbrake, and now I host them on a plex server.
My first adult relationship ended up being really abusive, and once I finally left after lots of nasty stuff, she started going to the police constantly for months accusing me of all sorts of stuff while stalking me at my new apartment, at my workplace, leaving threatening letters, all sorts of stuff.
Over all those months, the cops dutifully came to harass me every time she came up with a new conspiracy theory. I just wanted it all to be over, but it didn't end for a long time. I can only imagine how things would have turned out if I didn't ensure I had a good alibi from the moment I left her house that night.
Privileging anyone with an presumption of victimhood is dangerous. Particularly once those people realize they have that presumption, they can use it to turn the tools meant to protect abused into tools of the abuser.
That's one of the reasons why there needs to be an impartial process, because in the passion of the moment sometimes your lynch mob gets it wrong.
Over all those months, the cops dutifully came to harass me every time she came up with a new conspiracy theory. I just wanted it all to be over, but it didn't end for a long time. I can only imagine how things would have turned out if I didn't ensure I had a good alibi from the moment I left her house that night.
Privileging anyone with an presumption of victimhood is dangerous. Particularly once those people realize they have that presumption, they can use it to turn the tools meant to protect abused into tools of the abuser.
That's one of the reasons why there needs to be an impartial process, because in the passion of the moment sometimes your lynch mob gets it wrong.