Will ubuntu hang up in frozen state after huge sql query in psql ? (without tools like earlyoom)
(Yes, it will)
How in 2020 ubuntu (and linux-desktop in general) can be recommended as desktop operating system when it can't protect Xorg/Gnome/KDE from swapping out of RAM?
And you forced to use earlyoom and again drawn in some more configuration.
Also, snap packages are failure on idea level: people just need simple base system and sdk, without complicated security and other overcomplicated nonsense.
Back in the days ubuntu developers gained momentum in linux-desktop, but now it's lost.
But all his efforts are futile, because main linux-desktop problem is very complex fragmentation (someone religiously believes that it's linux-desktop main power, but we are not in 2003) — distros, DEs, widget toolkits (this mess with gtk or kde/qt look, not working gtk3-shadows in KDE because kwin developer is a child, gigantic controls in gtk3, and xfce as "alternative" to all this mess).
— Development SDK based on Qt (other toolkits strongly restricted, gtk and gnome gone wrong way)
— Packaging based on something like APK from android or like DMG (no repos by default, only for base system maybe, but other methods of installing not restricted).
Snaps and flatpack are trash because their goal is so called security and isolation, when normal human being need just convenience (hate repos on desktop).
Yes, it's macOS model, but with linux you can have different filesystems.