Not an Ubuntu user, but I think it's all about how a snap uses filesystem, esp directories which are not writable by the "world", such as your home directory.
Have you tried installing a non-snap version to confirm the theory?
ℹ I don't consider myself a Lisp expert nor a professional.
- Nowadays, I mostly use elisp to customise Emacs and write custom functions. Also some lines of CL using SBCL here & there to try out things.
- I've never used anything but Emacs for Lisp (lisp-interaction-mode and slime).
- I got my first Lisp book (I wanted to try out something different) when I got into the MSc in AI back in the university days. Turned out I wasn't really interested in AI and dropped out but the love for/fascination w/ Lisp never left 🙂
Interestingly "Bazzi" means "game" in Farsi 🤷♂️
Tell me something I don't know already 😂 The challenge is helping non-techies understand why they should wean themselves off of FB 🤷♂️
The GNU GPL is not Mr. Nice Guy. It says no to some of the things that people sometimes want to do. There are users who say that this is a bad thing—that the GPL “excludes” some proprietary software developers who “need to be brought into the free software community.”
But we are not excluding them from our community; they are choosing not to enter. Their decision to make software proprietary is a decision to stay out of our community. Being in our community means joining in cooperation with us; we cannot “bring them into our community” if they don't want to join.
By the gods! Why didn't I think about that!? 🤦♂️
Thank you!
root directory
Where your settings, bookmarks, passwords, etc are stored.
local directory
Where your cookies, website local storage and other temporary non-profile data is stored.
could not resize shared memory
That means too many chunky parallel maintenance workers are using the memory at the same time (max_parallel_maintenance_workers and maintenance_work_mem.)
VACCUMing is a very important part of how PG works; can you try setting max_parallel_maintenance_workers to 1 or even 0 (disable parallel altogether) and retry the experiment?
I did increase shared_buffers and effective_cache_size with no effect.
That probably rules out the theory of thrashed indices.
https://ctxt.io/2/AABQciw3FA https://ctxt.io/2/AABQTprTEg https://ctxt.io/2/AABQKqOaEg
Since those stats are cumulative, it's hard to tell anything w/o knowing when was the SELECT run. It'd be very helpful if you could run those queries a few times w/ 1min interval and share the output.
I did install Prometheus with PG exporter and Grafana...Anything specific you can suggest that I should focus on?
I'd start w/ the 3 tables I mentioned in the previous point and try to find anomalies esp under different workloads. The rest, I'm afraid, is going to be a bit of an investigation and detective work.
If you like, you can give me access to the Grafana dashboard so I can take a look and we can take it from there. It's going to be totally free of charge of course as I am quite interested in your problem: it's both a challenge for me and helping a fellow Lemmy user. The only thing I ask is that we report back the results and solution here so that others can benefit from the work.
I used to be in a relatively similar position years ago so I totally relate to what you've got to do on a daily basis.
These are the the titles that come to my mind (leaving ths seniority level up to you):
- Software engineer
- Software engineer in Integrations
- Software engineer in Enterprise Applications
- ERP Implementation consultant
"Do you not know my son, with how little wisdom the world is governed?" 🤷♂️
Would it make sense to stick to the good old DEB package instead of the snap then?
The Mozilla Team PPA seems to be legit. If you're not sure how to do it, please take a look at OMGI Ubuntu guide which uses the same PPA.