Hacker News Reader

__son WAL-RUS: a Rust Rewrite of WAL-G for PostgreSQL Backups

Correct. We tune overcommit so postgres reliably returns out of memory. It becomes complicated to accurately tune overcommit for every AWS instance type. We configure GOMEMLIMIT/cgroups but those are about RSS. Outliers come together: instances running queries out of memory on our service tend to also be pushing other resource limits, causing wal-g & prometheus exporters to start having more erratic memory usage at the worst time

This helps on both ends of the cost spectrum. Large 64 core instances are where our heuristics fall off the most as variance increases, & tiny instances with 8GB of memory can use every 100MB of RSS we can get

__son WAL-RUS: a Rust Rewrite of WAL-G for PostgreSQL Backups

no. but wal-g & wal-rus both have parallelism over wal-e. however are you more asking about handling build up of wal / vacuum prevention caused by long running transactions? those are up to postgres, archive command only keeps pushing wal so that when postgres is ready to get rid of wal it can. seems like your scenario wouldn't care much what the archiver is since wal should be shipped long before postgres is ready to get rid of wal

__son What If a Man Practised Shooting a Million Times? Shot 90172, Football Progress [video]

Is it really false? You can go on about survivorship bias but in the end a prerequisite is necessary for opportunity/chance

Can't win the lottery if you never buy any tickets

__son I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code

This is pretty much the case with every SQL dialect

__son Slate EV truck starts at $24,950

They're not organized: you go into the yard, find the vehicle you're looking for, take the part out yourself, & they weigh it on the way out

__son Slate EV truck starts at $24,950

https://www.andysautowreckers.ca they have a field of junk cars that people come in & harvest parts from

__son British Columbia, Time Zones, and Postgres

Seems like for airtightness you'd store utc alongside utc of when timestamp was stored alongside timezone

__son Inference cost at scale with napkin math

You can, people do. https://www.linkedin.com/posts/activity-7409593739138060288-...

__son PostgresBench: A Reproducible Benchmark for Postgres Services

Lack of protocol compression is painful with postgres

__son Ten years of ClickHouse in open source

Yes

https://clickhouse.com/resources/engineering/siem

https://clickhouse.com/blog/how-huntress-improved-performanc...

__son Can you see three trees?

Half dozen trees directly outside my window, but London Ontario is "the forest city" with an initiative to get 27% tree canopy to 34% by 2065

__son Ask HN: Will programmers write more efficient code during the memory shortage?

currently porting code from Go to Rust primarily motivated by memory efficiency gains

__son Ten years of ClickHouse in open source

Worked on peerdb. If you're able to batch changes on your end & push to both postgres & clickhouse, do that. Only move to peerdb when you know you need cdc

__son Peopleless economy? Not technically impossible

Landscape with Invisible Hand, only we grew the aliens instead of them showing up

__son How memory safety CVEs differ between Rust and C/C++

It's absolutely different: “I call it my billion-dollar mistake. It was the invention of the null reference in 1965. At that time, I was designing the first comprehensive type system for references in an object oriented language (ALGOL W). My goal was to ensure that all use of references should be absolutely safe, with checking performed automatically by the compiler. But I couldn't resist the temptation to put in a null reference, simply because it was so easy to implement. This has led to innumerable errors, vulnerabilities, and system crashes, which have probably caused a billion dollars of pain and damage in the last forty years.”

His mistake was making _all_ reference taking functions also accept null. In Rust functions opt into None | Some

This comes up with C# which must have default(T) so references default to null. In Rust there is no general default(T) that must always resolve

__son Hetzner Price Adjustment

Yep. With ai tooling I can keep prompting at 3am while sleep deprived. As a result I have mountains of slop plans / code to review. Hours of work which can't be matched by anyone who thinks they can poke a prompt for the day & go

__son Arch Linux Now Believes Malware Incident Under Control: More Than 1,500 Packages

I was concerned at headline, then saw "oh just AUR"

Next up, "millions of malicious packages still not taken down on internet"

__son WASI 0.3.0 Released

It has, but its usually just an optimization, so goes unnoticed

__son I Hate (Most) Keyboard 'Fn' Keys

for more info on thumb fatigue: https://getreuer.info/posts/keyboards/thumb-ergo/index.html

My issue was tendon overuse in my fingers, so low force switches & column splay worked for me

(splay is where the columns are not aligned, mapping to the fan out of the human hand, see TOTEM https://github.com/GEIGEIGEIST/TOTEM)

__son I Hate (Most) Keyboard 'Fn' Keys

I've switched to programmable ergo keyboards where there's a whole slew of options (https://precondition.github.io/home-row-mods just covers home row mods)

I've always hated stateful control. Always ripped out caps lock key from my boards (or later figured out remapping), same for insert mode

That's carried over, even with options like one shot mods, & cutting down to under 40 keys (& playing with 28, yesterday received a https://github.com/kilipan/zilpzalp), I still don't find stateful control necessary. More layers, combos, & tap-hold go far

__son Let's Encrypt bans certificate usage in any US sanctioned territory [pdf]

http://www.geekytattoos.com/illegal-tattoos-rsa-tattoos

tattoo yourself with crypto code to become munitions

__son PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit

we recently ran into trouble where PGroonga on the other hand needs overcommit enabled, in direct opposition to postgres preferences: https://pgroonga.github.io/how-to/tuning.html

__son PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit

"it's always something stupid" has been my approach to bugs for a long time. hindsight 20/20

__son Redis 8.8: New array data structure, rate limiter, performance improvements

Years ago I enabled durability on redis & used it as database for an online card game

__son New Beam Spring Keyboards

You get used to it quickly. Low force useful for combos

__son Shift from a leader-follower to a leader-leader approach

I worked in an office last year. We had these “Wacky Shirt Wednesdays.” On the first Wednesday I was able to participate, I decided to wear the shirt my mom was wearing when I was born. Now there’s some leftover placenta and uterine lining, so it isn’t the cleanest shirt. BUT it’s the thought that counts. That what momma says.

This f’n Karen decides to come over to my desk and tell me it’s “inappropriate” and “gross” and “ur mom’s placenta will get in my salmon salad”.

Win for me: keep wearing the shirt Win for Karen: stop having me wear the shirt Win Win Win: frame the shirt on my office wall so there’s never a chance of getting placenta in Karen’s salad.

Win Win Win!!

__son New Beam Spring Keyboards

I had to switch to low force choc couple years ago over tendon pain. Ended up on totem for day to day & bad wings for travel. 20g silent nocturnal switches. Silencing mechanism also gives bottom out a rubber feel, worth it just for that

__son The four programming questions from my 1994 Microsoft internship interview (2023)

The circle one is fishing for sonething clever. 90s without floats means no trig

__son The four programming questions from my 1994 Microsoft internship interview (2023)

Spoiler: https://gist.github.com/denkspuren/df24bf57ae3a44310631

__son Perry Compiles TypeScript directly to executables using SWC and LLVM

tbf Rust also can spit out pretty big binaries for small programs