Not for your use case. Only for their own streaming service. I've never been served an ad. And I've been using it for over a decade.
Well that would do it. Thanks for pointing out!
It thankfully seems to have been fixed thanks to @graycube@lemmy.world. Running analyze verbose; in postgres.
The pgautoupgrade was added for the new version because this deployment is an all-in-one solution for running lemmy. And upgrading the databases turned out to be quite the effort until some user pointed the maintainer towards pgautoupgrade here.
I tried running lemmy before I found out about this, but this just makes it so much more convenient to run.
Thanks. I ran it. Hopefully it'll make a difference.
Edit: It looks like this did the trick. I'll keep monitoring to see if it sticks. Thanks again!
I think so. I have lemmy and everything needed running through a single docker container using Lemmy-Easy-Deploy.
I added pg_stat_statements, and ran it. This was the result:
# SELECT count(*) FROM pg_stat_activity;
count
-------
11
(1 row)
ERROR: extension "pg_stats_statements" is not available
Even though it's added in the customPostgresql.conf
shared_preload_libraries = 'auto_explain,pg_stat_statements'
ERROR: extension "pg_stats_statements" is not available
Even though it's added in the customPostgresql.conf
shared_preload_libraries = 'auto_explain,pg_stat_statements'
I have. And I tried to tweak it with no avail. But it was working within acceptable levels before the update.
I have. It's running postgres v16.3
Your skin is constantly shedding. The dust you can find In a house is mostly dead skin. Applying sunscreen could make it stick instead of fall off. If it's dry it could also be dust and sand in the air.
Try scrubbing before going sunbathing to see if it still happens then.