Ah right, didn’t understand the “contract” part
It does it’s job but it’s suuper ineffective - you have to have a window open to suck in (hot outside) air that the portable AC cools itself with and throws out.
That open window even with that “sock” cover it comes with, lets back so much of the outside air and if you are like me renting a badly insulated flat, you are comfortable only when the AC is running, it won’t really cool down (and keep cool) the living space.
I do wonder why they don’t make a dual hose portable systems so that at least the unit is not pulling the air directly from the window, mixing already cool inside air with the hotter outside one.
I’ve been using FX File Browser for the occasional need to share stuff localy - it opens a local web server where you can browse files on the phone.
Though it’s not foss and I am afraid that functionality is behind the plus version.
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 just 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 increasing CPU
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/
Thanks!
Thank you for asking! Yeah, I am reading Stormlight Archive by B. Sanderson and their communities seemed to contain most memes specific to the lore haha
also RawTherapee
In what part exactly?
The example is not perfect I can see that myself. If I read into it too much there could be an overlap with concurrency, e.g. the (IO) tasks awaited & delegated to the OS could be considered a form of concurrency but other then that I do think it’s close to describing how async usually works.
What/who wrote this article? There seem to be extra words here and there
Matter of time, good while it lasted
Happy cake day !