What's the big deal with having a whole liquid cooled workstation, and why is it important information for me to know what this dude's hardware is? And seriously, is there something about the rig that is necessary to chew through a dataset with a few million rows?

Liquid-cooled computers have one major benefit; usually, your computer ages over time, and there's a long period where it's still barely fast enough but you wish you had something nicer. A liquid-cooled workstation prevents you from needing to manage this grey area by catastrophically failing at unexpected intervals.

He just does this with all his blog posts, don't overthink it. The tech industry is full of people with unexpected quirks.

I really don't think we should be shaming computer enthusiasts for being enthusiastic about their computers on HN of all places

The 9950X is an excellent CPU at a reasonable price point and works perfectly fine with an ordinary air-cooled heat sink in an ordinary case without stupid numbers of fans. The TDP is just not that high.

source: my 9950X, happily running air cooled.

(Embarrassingly, I have an M4 Max that can almost match it in the CPU-bound workload I care about while sipping some 45W. The rest of the industry really needs to catch up with Apple on power efficiency.)

It had a very 90s/early-2000s tech blog feel to it. Only thing missing was his custom Gentoo build.

Obviously he's telling you their spec incase you wish to reproduce his results. Why don't you try it and tell us how your result compares.

> 96 GB of DDR5 RAM

Most people drive cars worth less than this.

It's funny how I started skimming as soon as I saw "My Workstation" without ever consciously perceiving why I had started hitting Page Down, until you mentioned it and I went back to notice what it said there. My brain has really automated web page signal extraction.

If you're not familiar with his blog, he also occasionally does benchmarks of databases & extensions. He starts every post by outlining his setup.

Why is the top comment criticising a geek for being a geek? He gave us a wealth of information including his exact methodology and queries on how he produced his results. This is an ideal approach. You want just results and "trust me, bro"?

My initial thought was that was a weird choice in this article, but I wouldn't fault someone for being thorough.

Probably a better choice as an appendix, move the good stuff up to the top. But overall its NBD.

I had the exact same thought, particularly when I read there were fewer than 4M records.

I really have to wonder if people truly know how powerful any modern computer is. Like I just assume any modern PC with sufficient storage can handle a database with a billion rows of data. I think my phone probably could.

Now if you were, say, analyzing commercial satellite imagery of the entire US and trying to find rooftop solar, matching it against the database and finding data that wasn't in the dataset, that's something where your computer power would be way more relevant.

Come to think of it, you could probably use such imagery to construct a power generation network from power plants to transmission lines to utility poles. Of course some places have underground cables but there are other datasets for that.

Another interesting project is mapping the growth of solar. This would require access to commercial satellite imagery over time. I'm sure some government agency already does it. Or used to at least. Snapshots years or even months apart are less interesting.

Anyway, I guess the point is the author's computer is capable of way more than I suspect they think it is.