Ah, you are using pretty different deployment then, even the used postgres image is different then the usual deployment ( pgautoupgrade/pgautoupgrade:16-alpine instead of postgres:16-alpine) this might or might not cause differences.

I would try increasing POSTGRES_POOL_SIZE to 10-20, but I am guessing here, the idea being that lemmy is hammering postgres through the default 5 conns which increases CPU but that is a bit of stretch

do you also have pict-rs connected to this postgres instance? that is surprisingly low number to me, I would have expected anywhere between 20-50 active connections (I use 50 for lemmy and 20 for pict-rs, configured in their respective conf files)

extension “pg_stats_statements” is not available

According to this https://stackoverflow.com/a/72966651/5881796

The extension is not loaded: CREATE EXTENSION pg_stat_statements;

hmm, how many connections are used SELECT count(*) FROM pg_stat_activity; ?
I am not a master postgres admin but my intuition has been that the amount of connections is a big factor in how pg behaves with cpu and mem.

Do you have any tweaks of pg settings? Eg. shm mem, shared_buffers etc. ?

If not you migh want to: https://pgtune.leopard.in.ua/

Afaik you have to replicate the same wave but in opposite “direction” (up/down sinus) to cancel out incoming sound so any anc earbuds have to have microphones and are dynamically shaping the sound.

Registration hooks could be powerful

There are/were two reasons why I did that:

• board manufacturers like to push the juice into the CPU to make benchmarks look good which is dangerous with these power sucking bricks, afaik this might be already patched in recent bioses but I am not risking it/lazy to tweak back
• depending on the CPU piece you might achieve same performance with less power which is my case, I think I have Core Voltage set to something like Adaptive-0.080 which afaik is still pretty tame and the benchmark scores almost didn’t move

The only workarounds that seem to improve stability involve manually downclocking or undervolting Intel’s processors.

Guess that explains why I haven’t had any unexpected crashes yet with stuff like Palworld or Helldivers 2 (afaik both are made in UE). Have been running my 13900kf slightly undervolted.

nope

El Salvador needs to offload bags of BTC, loud and clear

Power and heat-wise to performance I was pretty satisfied with 3070 but it’s just a feeling and (bad) comparison because now I have 3080 and that chugs power huffs heat lol

in zsh just the - is enough for me though it might be a feature of oh-my-zsh config

One more, install and enable fzf in your .zshrc.

It makes ctrl+R (reverse history search) a lot better and cooler

And - to go back to where you came from.

If I had to guess (and simplify too) I would say that that would be the difference between your freshly compiled C program just dying with sigsegv then getting (mostly) peacefully cleaned up, or otherwise your system either flat out dying on you or even worse, something somewhere getting corrupted and the system spirals out of control possibly thrashing data and even hardware.

https://stackoverflow.com/a/1311432

Currently this process is rather painful as there is no way to look at all local communities of remote instance thru your instance and subscribe to them directly.

Instead there are two ways to get a remote community subscribed locally.

• https://github.com/lflare/lemmy-subscriber-bot
• Manually go thru various instances, open the list of local Communities on their site then copy the bang “link” [email protected] in the side bar or the whole URL (https://lemmy.ml/c/lemmy_support) then paste it in your instance under community search. It might take a second to load the remote community so wait or press the search again after few seconds.

You can also do the URL-in-search-bar trick with posts and comments to forcefully load/sync them locally.

Keep in mind that instances will push new community events (upvotes, comments, posts) only when there is at least on subscriber, so in the case you fetch the remote community locally but do not subscribe, it will not be be actively synced and only few posts will be visible (with possibly wrong karma/comment counters and so on).

I found a thread somewhere here or in lemmy issues about bans and I am pretty sure bans do not sync across instances, allowed or not.
Might also be wrong, new to this federation :)