Hacker News: fuy

New comment by fuy in "Molotov cocktail is hurled at home of Sam Altman"

fuy — Sat, 11 Apr 2026 17:44:17 +0000

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 class to make money/keep power etc. It's completely OK to protest laws, and it may be completely reasonable to consider someone a criminal even if they haven't broken any laws.

New comment by fuy in "OpenCode – Open source AI coding agent"

fuy — Sat, 21 Mar 2026 16:44:36 +0000

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

New comment by fuy in "The Appalling Stupidity of Spotify's AI DJ"

fuy — Sun, 15 Mar 2026 15:53:38 +0000

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 always 1-2 minutes long etc etc. It was like before AI though.

New comment by fuy in "Google workers seek 'red lines' on military A.I., echoing Anthropic"

fuy — Fri, 27 Feb 2026 09:00:08 +0000

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

New comment by fuy in "Unconventional PostgreSQL Optimizations"

fuy — Wed, 21 Jan 2026 08:22:33 +0000

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 are maintained automatically by Oracle/SQL Server.

New comment by fuy in "Let's be honest, Generative AI isn't going all that well"

fuy — Thu, 15 Jan 2026 11:37:27 +0000

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 sized (< million LOC), style is more uniform, there's fewer silos etc. etc.

Good studies look at a broader picture.

New comment by fuy in "The future of software development is software developers"

fuy — Wed, 31 Dec 2025 10:06:48 +0000

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

New comment by fuy in ".NET 10"

fuy — Wed, 12 Nov 2025 10:23:07 +0000

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 backend logic is not related to serving data for the browsers, it's doing actual backend stuff - communicating to databases, APIs, etc.

Is Google search backend a web app? I think it's really stretching the term.

New comment by fuy in "Optimizing ClickHouse for Intel's ultra-high core count processors"

fuy — Fri, 19 Sep 2025 09:10:22 +0000

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 not acquiring exclusive locks for reads eliminates by far the biggest problem.

Rare (I presume) cases of overlapping updates from different threads (considering updates themselves are also infrequent) don't seem like a big deal compared to lock elimination. Would be interesting to see benchmark numbers for those optimizations separately.

New comment by fuy in "Io_uring, kTLS and Rust for zero syscall HTTPS server"

fuy — Fri, 22 Aug 2025 10:26:58 +0000

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

New comment by fuy in "Linux Performance Analysis (2015)"

fuy — Wed, 30 Jul 2025 13:40:50 +0000

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

New comment by fuy in "Jepsen: Amazon RDS for PostgreSQL 17.4"

fuy — Wed, 30 Apr 2025 16:22:57 +0000

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 to be aware when doing this - it will break all code that rely on blocking reads (e.g. select with exists). These need to be rewritten using explicit locks or some other methods.

New comment by fuy in "Jepsen: Amazon RDS for PostgreSQL 17.4"

fuy — Wed, 30 Apr 2025 16:18:49 +0000

isolation levels, that is!

New comment by fuy in "Software engineering job openings hit five-year low?"

fuy — Fri, 21 Feb 2025 16:38:57 +0000

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. especially if it's before taxes.

New comment by fuy in "Microsoft open sources PostgreSQL extensions"

fuy — Fri, 14 Feb 2025 09:42:29 +0000

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

New comment by fuy in "Firing programmers for AI is a mistake"

fuy — Tue, 11 Feb 2025 15:55:14 +0000

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.

New comment by fuy in "Ten years of improvements in PostgreSQL's optimizer"

fuy — Wed, 24 Apr 2024 19:17:37 +0000

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 even with simple correlated subqueries, let alone "arbitrary", so it'd be useful to have at least some version of unnesting.

New comment by fuy in "Prolog language for PostgreSQL proof of concept"

fuy — Sat, 30 Mar 2024 18:18:17 +0000

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 3d party solution (or you're writing your own) straight away.

HA is complicated. Patroni is the best option now, but it's quite far from experience SQL Server or Oracle provide.

Optimizer is still quite a bit simpler than in SQL server/Oracle. One big thing that is missing for me is "adaptive" query processing (there's AQP extension, but it's not a part of distribution). Even basic adaptive features help a lot when optimizer is doing stupid things (I'm not gonna bring up query hints here :))

New comment by fuy in "Barcelona’s Sagrada Familia will be completed in 2026"

fuy — Tue, 26 Mar 2024 17:40:24 +0000

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 were probably above-the-median in their days, but it's not some singular building like Pyramids that is not representative of overall building of that era/territory. It was just how the houses were built there and then.

New comment by fuy in "What's new in the Postgres 16 query planner"

fuy — Fri, 09 Feb 2024 10:59:02 +0000

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