Comment on Slrpnk instance is down till mid July; they might relaunch their server on piefed.

• qweertz@programming.dev ⁨4⁩ ⁨weeks⁩ ago

  Postgres slowing factor

  I’m pretty sure one of the best optimised free/libre DBMS’s is faster than Python 💀

  Also no one know how Piefed scales, since it only has like 350 MAU

  source

  • JackbyDev@programming.dev ⁨4⁩ ⁨weeks⁩ ago

    Reread it. They’re saying “The slowest part is postgres, so even if python is slower than rust it won’t make a difference.”

    source

    • SorteKanin@feddit.dk ⁨4⁩ ⁨weeks⁩ ago

      That is, in theory. In practice, it can make a big difference. Source: Worked professionally with large services built in Python and Rust.

      source

      • Kris@feddit.org ⁨4⁩ ⁨weeks⁩ ago

        Yes, I also suspect that at a certain scale it would make a difference, but with a single Postgres database and no advanced clustering or so, the real-life performance metrics of a medium sized Lemmy instance strongly point to Postgres being the bottleneck and not the Python or Rust codebase of the rest of the software.

        source
  • PirateFrog@lemmy.dbzer0.com ⁨4⁩ ⁨weeks⁩ ago

    Piefed also uses PostgreSQL. He was mentioning that the limiting factor on either platform is the DB, meaning the fact that the frontend that’s written in Python will not be a limiting factor.

    Piefed also has quite impressive optimizations in other areas as well compared to Lemmy or even Mbin.

    source