From the river to the sea, Palestine will be free 🇵🇸

Admin of orcas.enjoying.yachts and web dev of nearly 2 decades.

  • 27 Posts
  • 1.7K Comments
Joined 3 years ago
cake
Cake day: July 7th, 2023

help-circle








  • orcaAtomemes@lemmy.worldCan’t buy RAM sticks
    link
    fedilink
    arrow-up
    3
    arrow-down
    1
    ·
    8 days ago

    I continue to use GamePass because you can download the games to your console, but if/when they go fully cloud-only, I’m out. That will be the death knell for mainstream consoles for me. I’ll stick to my Steam Deck and modded classic consoles.


  • orcaAtomemes@lemmy.worldCan’t buy RAM sticks
    link
    fedilink
    arrow-up
    5
    ·
    edit-2
    8 days ago

    Go back to old consoles like I’ve been doing. I’m in the process of modding a PS2, and I’ve got a 3DS that is on Pretendo Network and has a fuckload of games installed on an SD card.

    Edit: forgot to mention that I also recently threw my old BD burner into an external case. So now I can archive stuff to DVD like we did back in the day. I’ve been really leaning into reviving old tech.


  • Having the guest WiFi off the VPN is smart. I hadn’t thought of that.

    I’ll be honest, I only just learned about MLO. Basically what I know is that it automatically switches bands based on needs, and iirc it can use multiple at once. I’ve found that our WiFi speeds on all devices have been faster, and devices that support WiFi 6 and 7 are super fast. I still run the standard 2.4 and 5ghz to swap over to, but the additional MLO SSID has been fun to experiment with. No specific use cases. Just have a lot of streaming and gaming devices that need the bandwidth.




  • orcaAtomemes@lemmy.world*Permanently Deleted*
    link
    fedilink
    arrow-up
    2
    ·
    edit-2
    9 days ago

    I can’t remember exactly what I did but enabling autovacuum was one of the big ones. I’ll try to provide some info below:

    Walks through VACUUM and autovacuum - https://oneuptime.com/blog/post/2026-01-25-use-vacuum-analyze-postgresql/view

    How to see if autovacuum is already enabled (these are commands you’d run while in sql):

    SHOW autovacuum;

    View current settings:

    SELECT name, setting FROM pg_settings WHERE name LIKE '%autovacuum%';

    Monitor which tables need attention:

    SELECT schemaname, relname, n_dead_tup, n_live_tup 
    FROM pg_stat_user_tables 
    WHERE n_dead_tup > 1000 
    ORDER BY n_dead_tup DESC;
    

    I wish I had documented it at the time because info about this for Lemmy specifically is pretty lacking. I was in kind of a dire situation though because my disk space had filled up quickly and my system was struggling. A lot of what I did was basic PostgreSQL maintenance stuff, so you should be able to find some general guides for that.

    EDIT: I had Claude help me corral some optimization stuff into a PDF. This is along the lines of what I did to get my db back under control. Make sure to always backup first! https://u.orca.casa/1771250081






  • Explain to me what the troll is here. I read the entire post. Seems like someone got access to one thing and then tried their hand at others. Easy to do when your first point of access (the router) is setup poorly.

    I saw this happen years ago with a collocated Apache web server that the company failed to update Plesk on. Find one doorway and things fall like dominoes. We found hacks that weaved all the way into individual websites.