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.
Piefed also uses PostgreSQL. He was mentioning that the limiting factor on either platform is the DB, meaning that the parts written in Python will likely not be a limiting factor.
Our sysadmin explained some technical advantages here: https://feddit.org/post/13613230/7063696
I’m pretty sure one of the best optimised free/libre DBMS’s is faster than Python 💀EDIT: skimmed it wrongly, see corrections below
Also no one knows how Piefed scales, since it only has like 350 MAU
Reread it. They’re saying “The slowest part is postgres, so even if python is slower than rust it won’t make a difference.”
That is, in theory. In practice, it can make a big difference. Source: Worked professionally with large services built in Python and Rust.
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.
Piefed also uses PostgreSQL. He was mentioning that the limiting factor on either platform is the DB, meaning that the parts written in Python will likely not be a limiting factor.
Piefed also has quite impressive optimizations in other areas as well compared to Lemmy or even Mbin.