Viewing profile — fuy

The book is a companion to Machine Learning Systems https://mlsyscourse.org/ CMU course.

There's been many examples of societies where killing or abusing people was legal etc. Law is not math, it can be (and often is) wrong; in many cases a law is just a way for ruling…

claude code easily uses 10+GB in single session :) 1Gb sounds very efficient by comparison

almost all Spotify playlists/radio features are extremely stupid. Radios all repeat the same 2-3 songs per artist, doesn't matter where you start. Classical pieces in radios are al…

sorry about that, I appreciate the reminder. Sometimes it's hard to engage in conversations with obvious bots/bad actors in good faith.

[flagged]

CLUSTER command is not the same as index organized tables, it's a one-time "physical sort" operation. New data is not organized until you run CLUSTER again. Index organized tables …

Not saying you're wrong, but solo developers building (relatively) greenfield projects are the best bet for increased AI productivity. Solo dev projects are usually reasonably size…

isn't this template supposed to mean that all the previous considerations are now obsolete?

It's web in a (limited) sense that there's probably a web frontend somewhere, but this "somewhere" is usually pretty far away from where most of the code is developed. Most of the …

Looking at first optimization, I wonder if double-checking after acquiring exclusive lock brings any performance benefits. The whole premise is that cache access is read-heavy, so …

perf and look at stack traces (or off-cpu events for waits/locks). also, ebpf

Hey Tanel - I wanted to thank you for that blog post and psn tool - it recently helped me in a tricky performance investigation.

Had similar situation a few years before - switched a (now) billion revenue product from Read Committed to Read Committed Snapshot with huge improvements in performance. One thing …

isolation levels, that is!

Top 5% overall or top 5% of dev jobs? Former sure, latter might be not? I live in Prague, and there are definitely multiple companies that pay more than 90k to middle positions. es…

what about npgsql? it's pretty much official and is developed by Microsoft people

And also these old C hands don't seem to get paid (significantly) more than a regular web-dev who doesn't care about hardware, memory, performance etc. Go figure.

Thomas Neumann and Alfons Kemper papers can hardly be called "home-grown", their stuff has been implemented in multiple industrial systems. Postgres optimizer, though, is very bad …

I love and use Postgres daily for many years, but: Performance monitoring is pretty much absent, all you have is pg_stat_statements and friends. So for any serious scale you need 3…

Are you saying medieval Germany was richer than present-day Germany or USA? That's of course not true. And it's also not clear why you call it a survivorship bias - these villages …

Aurora is using native Postgres planner, I believe, probably with some minor enhancements.

One other thing about JIT that I feel is pretty crazy is that the generated code is not cached. I mean it's the most expensive part of the query execution a lot of the time, how co…

Or it could work in a way that the Planner has access to data about previous runs of each query, and it can use this data to change plans that were proven bad during execution. Thi…