It's fine until you run out of disk space

https://imgur.com/j0S32zL.jpg

Protip: Put swapfile on ramdisk for highest speed

Hopefully that swap is on an SSD, otherwise that query may not ever finish lol
Once you're deep into swap, things can get so slow that there's no recovering from it.

WHAT FUCKING QUERY ARE YOU RUNNING TO USE UP THAT MUCH MEMORY DAMN

Exactly how I plan to deploy LLMs on my desktop 😹

I'd be lying if I said I hadn't done something similar before.

You really need to index your tables. This has all the hallways of a Cartesian cross product.

I dunno why I didn't realize you can add more swap to a system while running. Nice trick for a dire emergency.

Does the OOM killer actually work for anyone? In every linux system I've used, if I run out of memory, the system simply freezes.

Slow SSD issue. RAM is for chumps.

Poor man's Optane

Swap thrashing goes brrrrrrrrrrrrr

I've actually done something similar with a 2GB ram machine... 2GB ram / 8GB zswap, actually ran way faster lol

Just download more RAM.

Jokes on you I used to have a 128gb ssd just for swap in my laptop

Shoot and I thought my 30 second SQL queries were a problem

Wait until you find about S3 and s3fs.

I don't want to see the EXPLAIN for that query. This person really needs to learn more about sql, I'd wager.