For anything important, use matrix instead of lemmy DMs.

  • 10 Posts
  • 405 Comments
Joined 3 years ago
cake
Cake day: June 22nd, 2023

help-circle


  • Good question. I don’t design these things.
    I’m not even an expert on databases.
    The way I understand it is that the 50 is a floor.
    Makes sense, you probably don’t want to vacuum too often, which might compete with other locked slots and have overall adverse effects.
    The work done while vacuuming is proportional to the table size, so vacuuming a small table is small work, while vacuuming a bigger table is more work.
    I guess that’s why it’s using a %.

    Thing is there’s no upper cap.
    Or there wasn’t until postgres 18+, and even then it’s likely way above what we’d run into.
    I imagine that it can make sense for many tables and the default might be conservative as to avoid the drawbacks of over vacuuming.

    Even an upper cap would only shorten the amount of time before it fixes itself.
    In our case, the issue was mostly due to the database upgrade which basically resets the counters towards the next run.

    I’ll probably just add a daily job that takes care of this more gracefully without being too agressive.
    Regardless, this should probably be added to the upgrade process.






  • The old jank engine is honestly pretty good for atmospheric storytelling.
    Sure, Cyberpunk is shiny and all, but there’s something about Bethesda.
    Idk how to explain, corpses in Fallout never despawn. That item you hid in the bush? it’s still there 300h later. It has a certain persistence that isn’t that common.
    It can also feel stale real quick though.
    Especially when you get into janky bugs.
    But all this needs an interesting premise, story and vision.

    I don’t have much hopes for whatever they release next.
    Nor from any AAA.
    Games is art and art is incompatible with the corpo mindset of most game companies these days.

    I’d rather play something that was made with passion than with greed.