For anything important, use matrix instead of lemmy DMs.

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

help-circle


  • I mean sometimes I’ll suck at coming up with something meaningful or expressing properly in the moment.

    I’ve written countless dubious birthday card messages along the lines of:

    • I suck at writing messages, but I’ve really enjoyed ________ with you. I look forward to _______
    • I’m really wasted and can’t write for shit at this time but I love you.
    • yadayadayada, act really touched, yadayadayada.
      Damn, that sauce was really great, I got high hopes for dessert. Anyway. Don’t actually cry, but like, you know, fake the one single tear thing? Yeah yeah. Alright let’s hug. Seriously though, we should grab a drink after. See ya around.

    Literally anything other than slop










  • 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.