![](/static/253f0d9b/assets/icons/icon-96x96.png)
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)
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/
also RawTherapee
Oh interesting I will have to look how tessaract does it
What a dumb way to do image proxying.
This is about proxying external images, URL rewrite won’t work unless the image is also downloaded and hosted by the instance (which seems even worse for many reasons).
Or am I missing something here?
Yeah kinda, unix socket does count as ipc
Alternatively you could use capabilities:
I have been pretty content with just zsh with fzf - extends the ctrl+R with interactive fuzzy search across the history.
In theory some session like behaviour should be easy to make with a little script that changes $HISTFILE
Using pip to install packages outside of venv was always a risk, (newer) pip now has this mechanism to really drive the point home that this can break stuff.
Do I have to do this everytime I start the script via console?
Yes, one way to get rid of this requirement is to package the script as binary/executable package (add pyproject.toml with some sane defaults and with proper [
) and then install the project using pipx - ]pipx install -e path/to/the/project/
, the -e
flag stands for editable and is nice to have here as you won’t have to reinstall everytime you change the script.
What pipx does is that it creates the local virtualenv, installs everything the package declares as needed and adds a special executable script into location like ~/.local/bin/
that first sources the venv and then starts the entry script - keeping everything isolated.
You will want to use virtualenv, it creates isolated “workspace” so that system (python) packages do not conflict or mix.
pipx won’t work for that, it’s a library.
If you are working on your own project/script, you should use virtualenv for development and install all required libraries there.
If you need it because some system installed application or part of your system does not work without it then… you are in bad place - pip is python package manager primarily used for general python development (installing depending packages, and in theory also for packaging python projects) but it should never be used as system wide package manager - you will break stuff (especially when used with sudo).
https://unix.stackexchange.com/questions/450008/pip-vs-package-manager-for-handling-python-packages
https://unix.stackexchange.com/questions/734792/difference-between-installing-a-package-with-apt-and-pip
If you need to install an executable python program, use pipx
it will create special environment for the python program so it won’t break anything else in the system but it only works on packages (pipx install some-package
) that have entry scripts (so can be called directly, libraries usually do not have that as you use them from other python program).
In short that error you get that tells you to use zypper is there for an important reason.
The first time her videos popped up on my feed I couldn’t believe it’s not some elaborate joke, but shes great
What does lsblk -f
show ?
For me, Steam (on Linux) has been periodically corrupting the ntfs disk, I do use it on windows too and not even win hybrid/fastboot/hibernation disabled helps.
May I see what mount options you use for the ntfs3
driver in fstab? I do not currently have the nocase and windows_names …
https://github.com/Nixola/VRRTest
Also afaik it only works in fullscreen on Linux (and in programs that support it).
Yeah NX is probably not going to be an easy one to implement.
https://en.m.wikipedia.org/wiki/NX_technology Scrolling down to NX Derivatives And Forks will quickly get you a picture about the state and licenses.
Ah, you are using pretty different deployment then, even the used postgres image is different then the usual deployment (
pgautoupgrade/pgautoupgrade:16-alpine
instead ofpostgres: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