Sunday, lemmy.ml is performing better than I have seen it in 60 days. I did get errors on Saturday and significant lag. Not sure if activity is just today or what, but it’s really been fast in routine browsing.

Who are you? I am published author Stephen Alfred Gutknecht, an expert in messaging systems and operating systms. Do you have evidene and facts? (I do have brain damage)

Can you identify who you are?

Can you answer details about GitHub issue 2910 on Lemmy project and the date?

I am sorry to all the never-joined, never-stayed users of Lemmy in May, June, July 2023 “Tweet is X”, “Reddit is $API” ------ because I could not draw enough attention and developers to Github Issue #2910 avoidance. I failed entirely in my social effort I tried to do for 60+ days. I really failed, brain damaged fuck-up I am. The worst failure in my life, and it’s the end of the line.

I’m not sure if there’s a minimum Postgres version specified anywhere in the docs, I took a quick look but couldn’t find it.

I do not find it in the “From Scratch Install” documentation. I will work to revise those documents this weekend to warn people that 0.18.3 and later is incompatible. Thank you again for sharing.

docker compose down &&

Looks like the & parsing in code blocks is another bug in 0.18.3 like the post title one. I’ll add your comment to the GitHub issue.

Thank you for sharing.

Heads-up that a new issue on GitHub reporting this problem upgrading from 0.18.2 to 0.18.3:

thread 'main' panicked at 'Couldn't run DB Migrations: Failed to run 2023-07-08-101154_fix_soft_delete_aggregates with: syntax error at or near "trigger"', crates/db_schema/src/utils.rs:221:25 note: run with 'RUST_BACKTRACE=1' environment variable to display a backtrace

https://github.com/LemmyNet/lemmy/issues/3756

If you use “Lemmy from scratch” install,

you may be on an older PostgreSQL that Ubuntu distro provides, not the same as the Docker install method.

Heads-up for anyone who compiles the Rust code from source and is testing/integrating their own manual changes/patches to the code… the main git branch is not what Lemmy 0.18.3 is based on. https://github.com/LemmyNet/lemmy/issues/3602

Great, thank you. The network is much more stable and working solid!

The server returned this error: couldnt_find_object

I opened an issue on Github, I guess they didn’t see the comments I made about the problem in 0.18rc6 announcement posting.

https://github.com/LemmyNet/lemmy/issues/3296

Query speed is Lemmy’s main performance bottleneck, so we really appreciate any help database experts can provide.

I have been pleading that Lemmy server operators install pg_stat_statements extension and share metrics from PostgreSQL. https://lemmy.ml/post/1361757 - a restart of PostgreSQL server is required for the extension to be installed. I suggest this be part of 0.18 upgrade. Thank you.

I think lemmy.ml restarting the server helped the ‘pending’ subscribe problem, it started to come back for me once the server had been running an hour or more post-upgrade. It’s better, but I still am having some get stuck.

Missing comments and postings are also not as glaring in the user interface as a ‘pending’ subscribe.

Lemmy development really needs another couple weeks or a month. There are over 100 instances peering and it’s really pushing the database systems hard with the 100,000 users already. Database tuning and query optimization in the code is the order of the day. I also think some of the new front-end apps for web and smartphones would help.

9 years ago, Reddit was open source. the community didn’t seem to want to have alternate owner/operators on any significant scale.

I did a search ‘site:lemmy.ml’ and a lot of pages came up. ‘site:lemmy.world’ returns 296 results for me.

And I would like to see a federation-wide policy that all bots must be clearly identified as bots (an attribute on their account). And features in the site code to block all bots as a user preference.

Does this work: !thescarydoor@kbin.social

Try 2: thescarydoor@kbin.social

Not really, from lemmy.ml it ends up being a hyperlink over to the other website instead of a local community reference.

There already is a Futurama community on https://lemmy.world/c/futurama

Or CNN or MSNBC or NPR or …

Or QAnon memes from some nameless “Q” they don’t even know, they flock as hard as they can, making Q flags. You name HDTV networks, I see most people staring into smartphones and flocking from signal to signal.