bahmanm

Oh, updated the link 🤦‍♂️

The stock Grafana dashboard for PG is a good starting point. At least, that's how I started. You really should add new metrics to your dashboard if you really need them as you said.

Don't forget to install node-exporter too. It gives some important bits of info about the PG host. Again the stock dashboard is a decent one to start w/.

Extensions either save their settings in the "cloud" or locally.
If you've got Firefox Sync setup, the ones which write to "cloud" will be automatically backed up for you.
Some extensions also offer to export your config to a file so that you can import it later.
It all varies by extension and impossible to tell w/o knowing which ones you're using.

That said, you can always safely experiment using a new profile w/o needing to delete the current one. Create a new profile (launch firefox using firefox -P) and see if copy-paste works properly in there. If yes, then you can add your extensions one by one to the new profile w/o losing your settings.

I've never had this problem so can't tell for sure. But have you tried the solution in the very link you shared?

Also had copy/paste not working on some sites. Noticed that dom.event.clipboardevents.enabled was set to false. Set it to true on about:config page, now everything works.

A few things off the top of my head in order of importance:

• How frequently do you VACCUM the database? Have you tried VACCUMing a few of times over a 5 min span & see if there are changes to the disk I/O aftewards?

• I've got no idea how Lemmy works but "seeding content", to my mind, possibly means a lot of INSERT/UPDATEs. Is that correct? If yes, there's a chance you may be thrashing your indices & invalidating them too frequently which triggers a lot of rebuilding which could swallow a very large portion of the shared_buffers. To rule that out, you can simply bump shared_buffers (eg 16GB) & effective_cache_size and see if it makes any difference.

• Please include a bit more information about PG activity, namely from pg_stat_activity, pg_stat_bgwriter & pg_stat_wal.

• You've got quite a high value for max_connections - I don't believe that' s the culprit here.

And finally, if possible, I'd highly recommend that you take a few minutes & install Prometheus, Prometheus node exporter, Proemetheus PG exporter and Grafana to monitor the state of your deployment. It's way easier to find correlations between data points using the said toolset.

I missed the point wrt 2021. That's somehow comforting/reassuring. Thanks.

RE text: Agreed. I have started a humble campaign (read "one man army 😁) to try to address this insane trend. Joining forces is sincerely apperciated!

I'm not at my desk ATM but I think this is a prime usecase for crosstabs.

I wonder what would that mean for openSUSE, given that, apparently, an equity firm is making decisions on behalf of the SUSE board 😞

Yes. I wrote down the procedure a few weeks ago which may come in handy for you as well: https://www.bahmanm.com/2023/07/firefox-profiles-quickly-replicate-your-settings.html

I've got an old ThinkPad w/ 16GB RAM. My daily workflow is a combo of Emacs, a bunch of JVM languages, Make, Docker and minikube. I've been running openSUSE Tumbleweed for ages and am quite happy w/ its performance, package availability and being up-to-date.

Bookmarked!

I've got an old ThinkPad (2011 T530) and I run Linux (openSUSE Tumbleweed.) I haven't done any tinkering/tweaks and the performance is great.