380
Permanently Deleted (lemmy.world)
submitted 8 months ago* (last edited 8 months ago) by to c/memes@lemmy.world
146 comments fedilink hide all child comments
 

Permanently Deleted

you are viewing a single comment's thread
view the rest of the comments
[–] 130 points 8 months ago (12 children)

Damn this should honestly be spread and talked about more. I don't think many people know this is a thing?

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 12 child comments
    •
  • [–] 131 points 8 months ago (11 children)

    Considering PieFed users won’t shut the fuck up about how much better and less politically opinionated it is, yeah we should probably shout this from the rooftops.

    Reminds me of Brave browser users a bit

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 11 child comments
    •
  • [–] 15 points 8 months ago* (8 children)

    One of PyFed's selling points was that it was easier to work with than Lemmy. It's going to be amusing when that takes a 180 turn and people start complaining.

    Python is great for prototyping and iterating on small projects or as glue for modules written in C and C++. What it isn't great at is linearly scaling on a single node. When the day that throwing more powerful hardware at the problem stops being an option, Kubernetes is going to walk through that door and fuck any semblance of simplicity up.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 8 child comments
    •
  • [–] 8 points 8 months ago (5 children)

    I think Lemmy has some in-memory data structures that limit the backend to a single node, too. Also postgres is great, but Lemmy really fucked up their database performance somehow.

    But yeah large python codebases turn into spaghetti really quickly.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 5 child comments
    •
  • [–] 3 points 8 months ago (2 children)

    but Lemmy really fucked up their database performance somehow.

    Can confirm. I spent like 4 hours one day configuring auto vacuum and other shit on my Lemmy DB because it was bloating to hell and eating up resources. Runs much smoother now but it was a massive PITA to get there.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 1 point 7 months ago (1 child)

    Old post, but can you share what you did? I'm fighting the same problem.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] 2 points 7 months ago* (last edited 7 months ago)

    I can’t remember exactly what I did but enabling autovacuum was one of the big ones. I’ll try to provide some info below:

    Walks through VACUUM and autovacuum - https://oneuptime.com/blog/post/2026-01-25-use-vacuum-analyze-postgresql/view

    How to see if autovacuum is already enabled (these are commands you’d run while in sql):

    SHOW autovacuum;

    View current settings:

    SELECT name, setting FROM pg_settings WHERE name LIKE '%autovacuum%';

    Monitor which tables need attention:

    SELECT schemaname, relname, n_dead_tup, n_live_tup 
FROM pg_stat_user_tables 
WHERE n_dead_tup > 1000 
ORDER BY n_dead_tup DESC;

    I wish I had documented it at the time because info about this for Lemmy specifically is pretty lacking. I was in kind of a dire situation though because my disk space had filled up quickly and my system was struggling. A lot of what I did was basic PostgreSQL maintenance stuff, so you should be able to find some general guides for that.

    EDIT: I had Claude help me corral some optimization stuff into a PDF. This is along the lines of what I did to get my db back under control. Make sure to always backup first! https://u.orca.casa/1771250081

  • permalink
  • fedilink
  • source
  • parent
  • [–] 2 points 8 months ago*

    large python codebases turn into spaghetti really quickly

    I don't think the language is the problem here. Seeing as Python isn't somehow severely limited in its expressiveness or organization. Static typing isn't a cure against spaghetti.

    However, code in that particular file doesn't inspire any faith in the authors' organizing skill.

  • permalink
  • fedilink
  • source
  • parent
  • [–] 1 point 8 months ago

    People are already complaining (see: this very thread:-), but also note that people are complaining about Lemmy too - e.g. slrpnk.net about to switch to PieFed, due to frustrations with long-standing bugs.

    People always complain, the important thing is to move forward with something that is going to work. Personally I think Lemmy will not, though I would be happy to be proven wrong, and I am pinning all hopes on PieFed - worst case there is that they both succeed, which would be fantastic 😍.

    Yes I hear what you are saying about resources and complexity (learning Rust is somewhat complicated as well though...), but right now the subscriber counts across the entire Threadiverse are dropping not rising, so that will be a wonderful problem to have to solve one day, if we ever get to that point.

  • permalink
  • fedilink
  • source
  • parent
  • [–] 11 points 8 months ago* (last edited 8 months ago)

    "Ours is not biased and less opinionated, because it agrees with my bias and opinions."

    This is every single Lemmy v PieFed argument. No matter what platform you host or use, its just this on the grand scale of things.

  • permalink
  • fedilink
  • source
  • parent