HNHacker News
TopNewBestAskShowJobs

hunterpayne

473 karma · joined September 14, 2025

submissionscomments
hunterpayne··on Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD
This is the case when you have your own datacenter. This isn't as big a problem in the cloud. There are ways to write licenses that prevent cloud providers from stealing while allowing customers to use the software and being required to pay for it. The problem with the AGPL has to with its viral nature, not its provisions to prevent cloud vendor theft.
hunterpayne··on Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD
Its 300x faster for certain tests. I could pretty easily craft tests that do this on two different systems. The author mentioned this when they talked about being able to fit an entire ResultSet into memory. That's the real trick with performance. Very few workloads are CPU bound anymore (linear algebra on the CPU for example). Almost all workloads are memory bound. So its all about moving data from memory to network, back to memory and back to network, over and over again through your microservices or DBs. If the entire working set can fit in memory, you get at least a 10x performance boost. If you have to keep even a part of the working set on disk, its a huge performance loss. And the larger fraction of the working set on disk, the worse the performance loss.

PS Learn how DBs do joins for more information. Specifically the differences between hash joins, merge joins and nested loop joins. They are basically fancy ways to page part of your working set to disk at huge performance penalties.

PPS As memory gets more expensive, these techniques get more valuable. When it gets cheap, they lose value.

hunterpayne··on Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD
No. This is system code. You let an LLM loose on it, it probably fixed 20 bugs and introduces 200 more plus 5 different performance regressions. In all fairness, your average app programmer would have the same problems. That's why it takes so long to learn to be a system programmer and why it takes so long to do anything on a systems source base. For reference, systems are OSes, DBs and compilers (although compilers are very different in many ways).

Also, you can successfully sell a systems project that is only 10% faster. 30000x faster and they are throwing illegal and debauched things through your window to get access to your improvements.

hunterpayne··on Born Against, or why hobby programming communities are against LLM usage
I'm not the farmer who posted...so no.
hunterpayne··on Born Against, or why hobby programming communities are against LLM usage
So just like before the industrial revolution then. Because back then (pre-1750 or so), most goods were made for the wealthy as well.
hunterpayne··on Born Against, or why hobby programming communities are against LLM usage
You just dated yourself to a very specific time. Before that, Sun was the gold standard and Apple was known for terrible software. I still use a 30 year old text editor because it just works better than modern editors. There are plenty of examples. If you don't know of any, its because you just accept the slop with marketing dollars behind it. I can't say I blame you, finding good software seems to require more and more effort with each passing year. I blame the amount of money in software for that. Gotta take the good with the bad.
hunterpayne··on Born Against, or why hobby programming communities are against LLM usage
That and a large amount of bots operated by people with a financial interest in LLMs succeeding.
hunterpayne··on Born Against, or why hobby programming communities are against LLM usage
Did someone seriously just down-mod a farmer in a sub-discussion about running a farm?

PS To the "clear-thinking" guy at the top of this thread...this is why...you only think your thinking is clear. If its a topic you know nothing about, devs (not necessarily you) tend to assume there isn't anything to know and that's almost never true.

hunterpayne··on Born Against, or why hobby programming communities are against LLM usage
"The basic services that keep us alive (e.g. farmers producing our food) tend to also be "easy""

The reason you think that is that you know nothing about agriculture. But it isn't true. Right now, farmers in the US grow about 5x as much food per acre as farmers in other countries. If you were in charge of farming in the US, that surplus would likely disappear in a single season. You would also likely damage the soil which would make cleaning up after you take 4-6 years.

Everyone thinks things they know nothing about are easy. But they rarely are.

PS This is why I never tell people I'm a programmer. I don't want to be associated with people who think like you.

hunterpayne··on Born Against, or why hobby programming communities are against LLM usage
And its been that way for at least a decade.
hunterpayne··on U.S. used 'virtually all' of its long-range precision missiles during Iran war
The US only used long range precision missiles for the first 3 days of the war. Since then, its been almost all JDAMs. The interceptors got used a lot more but even with those we only went through about 5% of the stockpile. This is CNBC. If you trust them on topics like this, well...that's on you. Please remember that they don't have a single person on staff with any military experience or expertise.

PS Their source was probably the IRCG...

hunterpayne··on Germany Records Historic 12B KWh Solar Feed-In in July 2026
By 2017, only 3 German NPPs were online. So multiply those NPP numbers by 5x. Also, your claims about the German grid are non-sense. Germany produces several times as much CO2 per watt generated as the US and about 7x more CO2 per watt as France. You seriously don't even know enough to calculate these numbers correctly.
hunterpayne··on It's not a fear of "AI communism"; it's a fear of competitive market capitalism
Its State Capitalism (which is a complete misnomer), in about 2% of the country which is in "special economic zones" around major ports. In reality it is "socialism with Chinese characteristics". The number of own goals the CCP has made in the last decade is quite large. But when your opponent is making a mistake, don't interrupt them. Without the CCP, China would probably have the world's largest economy right now. Because of them, they aren't even close and have a median per capital GDP on par with Namibia. Seriously, the amount of propaganda about this topic is amazing.
hunterpayne··on It's not a fear of "AI communism"; it's a fear of competitive market capitalism
Hate to break it too you, but LLMs made an awful lot of the content people thought came from the Gaza war. There was a small group of people who tried to help the media verify content for publication but the many in the media didn't seem to actually care if the videos were real or not.

Someday, the publishing of LLMs that generate video will be the thing historians talk about most from this period of history. Even if the vast majority of people today don't realize it has been happening for a couple years at this point.

hunterpayne··on Germany Records Historic 12B KWh Solar Feed-In in July 2026
There is nothing resilient about renewables. Ask Spain about that. They aren't disrupted by one shock event but instead they are disrupted almost daily (and I'm not talking about nighttime). Also, Europe is too far north for Solar PV to make any sense at most of the places that people actually live...like Germany.
hunterpayne··on Germany Records Historic 12B KWh Solar Feed-In in July 2026
The rare earths do come from China and that's where most of the environmental damage they cause happens. Rare earths can be mined almost anywhere. They aren't rare but they also aren't concentrated because they aren't water soluble. They are mined in places that don't care about environmental damage, not in places where specific geologic conditions exist (like everything else except AL). Also, you need them to make generators. When you put those generators in wind instead of in hydro or nuclear, you waste them. This is because they will generate 6 to 9 times as much power in hydro or nuclear plants as in a wind turbine.
hunterpayne··on Germany Records Historic 12B KWh Solar Feed-In in July 2026
The GWOT was 7% of the US military budget. Also, the US doesn't get oil from the Middle East anymore. Its been about 10 years since we did.
hunterpayne··on Germany Records Historic 12B KWh Solar Feed-In in July 2026
For reference, that's about 4x the worldwide average electricity price.
hunterpayne··on Germany Records Historic 12B KWh Solar Feed-In in July 2026
How is closing your nuclear plants working out for you?

Germany burns the lowest grade coal known to man to make up for the loss of its nuclear fleet. Germany has one of the dirtiest grids in the world and the dirtiest grid in the developed world. And for reference, a single NPP makes roughly 600 GW hours of power a month. Germany closed down about 15 NPPs which would make several times as much power as the solar PV in the article. More than enough to power everyone's ACs.

hunterpayne··on Why is everyone trying to build a solid-state battery?
No...its valuable to know if the drone did its job. That and the extra expense of the boards makes it not really so useful in practice.
hunterpayne··on Why is everyone trying to build a solid-state battery?
They prefer what works. So it depends on the EM jamming the other side has at that point in the line. Some parts of the line are covered in old fiber optic cable because they are near somewhere important so the Russians have EM jammers there. Other parts of the line, they probably only use radio drones. Also, the ways the drones talk to the operators has changed at least 3 times throughout the war. So by the time you read this, it might have changed again.

Also, the last big change is network relay drones that fly at a few 1000 ft that allow other drones to have more range. The AI thing hasn't played out because the boards are too expensive to use in 1-way kit.

hunterpayne··on Baseload Is a Myth (2024)
This article is largely non-scientific propaganda. LCOE is a fake stat that is never used to actually calculate any cost at any point. And anytime you use variable generation, you need to keep a spinning reserve, otherwise you get a blackout like what happened in Spain. HN should be ashamed to post such an article full of misinformation and half-truths not based on how engineering actually works.
hunterpayne··on Show HN: Bullshit Detector – agent skills that fact-check videos and articles
Cool, now do Fauci...

PS I've always assumed all politicians lie, I'm sure you don't think Pelosi or Bush Jr for example were some paragons of truth. Doesn't make it OK, but have some perspective.

hunterpayne··on Show HN: Bullshit Detector – agent skills that fact-check videos and articles
It also doesn't help that many news sources will knowingly fudge the truth. There are topics about which they are constant sources of misinformation. Seems like depending on the topic (anything science related) you wouldn't want to use news sources at all. Other topics, you probably only want to use news sources. And arranging all of this weighting of sources is going to be difficult and controversial as well. Doesn't mean it can't be done. Doesn't mean it wouldn't be valuable. But there is a lot to it and most of it isn't so much about technology or math as it is about understanding who should and shouldn't be considered authoritative about what topics.

Sounds challenging to me...

hunterpayne··on The only road in London where you have to drive on the right
The US drives on the right (which is the right) side. So why would the US switch? Its really just Australia, Japan, India and the UK that drive on the left. The other 190ish countries all drive on the right.

PS Your 240V electric grid works that way because when the US switched to 120V (in like 1900 or so), we sold all our old gear to you and you never switched. So now all your electric things cost more as a result and your electrical outlets will kill you. So your decision making on such things is suspect.

hunterpayne··on Stop Killing the Internet: No Digital ID and No Age Verification
Only the "kids" hardware needs this. The adult/anonymous Internet doesn't. That's the whole point.
hunterpayne··on Stop Killing the Internet: No Digital ID and No Age Verification
As I said, it depends on the state. I've had to sign for wine before.
hunterpayne··on Stop Killing the Internet: No Digital ID and No Age Verification
You don't allow adults on the kids sites. So your theoretical pedo would have to provide ID to get the "kids" hardware. And the "kids" hardware can't go on the normal/adult/anonymous Internet. Done...

For the EU, this has nothing to do with kids.

hunterpayne··on Stop Killing the Internet: No Digital ID and No Age Verification
That's a good point. However, its possible to police YouTube Kids without destroying free speech. Policing the entire Internet and everyone else...not so much. That's the whole point of having the companies providing "kids" sites to register and have a specific set of regulations about the "kids" sites. Perhaps those regulations include parental controls.
hunterpayne··on Stop Killing the Internet: No Digital ID and No Age Verification
You assume you will always like and agree with your current government. And there are European countries who already jail people for political speech the government doesn't like.
← PreviousPage 6 of 33Next →