DosDude

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

Obvious bait is obvious. But sbc gaming is really awesome, just not the subject in this context.

If it runs fine on an SD card, it also runs fine on a HDD. You don't need to compare it to an SSD.