• 0 Posts
  • 84 Comments
Joined 2 years ago
cake
Cake day: June 12th, 2023

help-circle


  • Really depends on many factors. If you have everything in RAM, almost nothing matters.

    If your dataset outgrows the capacity, various things start to matter, based on your workload. Random reads need to have good indices (also writes with unique columns), OLAPs benefit from work_mem, >100M rows will need good partitioning, OLTP may even need some custom solutions if you need to keep a long history, but not for every transaction.

    But even with >B of rows, Postgres can handle it with relative ease, if you know what you’re doing. Usually even on a hardware you would consider absolutely inadequate (last year I migrated our company DB from MySQL to Postgres, and with even more data and more complex workflows we downsized our RAM by more than half).






  • It’s voice and video calling with chat and screensharing. I intend to use it for a language school. It’s extendable, for instance you can also self-host a whiteboard, where everyone can draw. You can see the drawing in real time, which is good for asian languages, where direction of the stroke is important.

    Free, open-source, packaged in Debian, runs without issues, used it with friends for multi-hour voice chats during gaming nights.

    On the server you can configure things like FPS for screenshare. I have yet to adjust that and try streaming video/game through it.









  • You are right, but let me add that Gabe knows that being tied to Windows is not a good idea, as he worked there and understood that they would block Steam if they could.

    Valve supporting ‘their’ alternative OS, away from Microsoft (and Apple) or any other direct competitor in gaming is the only way to survive.

    It’s not like they pour all that money into Linux from the goodness of their heart. They need their own OS just as much as the Linux desktop community needs some stable funding.

    Given how Valve lets children gamble with skins, I’m not sure how moral that company really is.