HNHacker News
TopNewBestAskShowJobs

tomnipotent

4,354 karma · joined August 11, 2014

submissionscomments
tomnipotent··on Training a 4B model to produce 81% faster query plans than Postgres
Which is why a good query plan is so important, so that as much disk I/O can be avoided as possible (predicate push down, index elimination, join ordering, partition/scan pruning). Like the old CTE optimization fence problem.
tomnipotent··on Amazon vs. Perplexity – U.S. Court of Appeals for the Ninth Circuit
Ads are 10% of their revenue. Not insignificant, but not a "large part".
tomnipotent··on 118M Queries per Second on Neki
Less than 5% of commercial storage capacity was SSD of any flavor in 2015 (NVMe probably less than 1%), and the price-per-GB was anywhere from 5-15x. NVMe hardware RAID didn't happen until 2017, and AWS SSD via EBS was capped at 320 MB/s (~500 MB/s with striped EBS volumes). Before 2015 it was capped at 160 MB/s.

In practice even NVMe SSDs at the time were maybe 10x faster for sequential R/W and maybe only 200-500x for random I/O. Most databases in 2015 were limited by serial dependency chains like walking a B-tree to figure out what nodes to read next and couldn't max out what an NVMe was capable of. Not to mention we were stuck with libaio in 2015 that made O_DIRECT ops synchronous.

So the OPs claim of reading multiple terabytes of data in seconds on AWS in 2015 literally wasn't technically possible.

SSDs simply were not as ubiquitous in 2015 as they are today, and I didn't know anyone using them outside of mission critical systems were the cost made sense.

tomnipotent··on 118M Queries per Second on Neki
Not in 2015. 25GBps didn't even arrive until 2016, and dedicated EBS bandwidth didn't arrive until 2017.
tomnipotent··on 118M Queries per Second on Neki
> all the signals from the offline files in mere seconds

That sounds unlikely unless those machines had access to crazy disk I/O. A local RAID 5/10 with 8 drives would still take 30-50 minutes just to read that much data. Even with a mid-range SAN you still would have spent 15-25 minutes just reading data. This assumes 7.2K SAS/SATA since SSD/NVMe were not ubiquitous in 2015, but even with 2015-era SSDs you're still looking at half that much time spent reading.

tomnipotent··on Shopify is moving from React Native back to Swift and Kotlin
Yes, Shopify GMV is roughly half of Amazon.
tomnipotent··on Shopify is moving from React Native back to Swift and Kotlin
Shopify is not far behind Amazon (the e-com business). It's network sees as many unique visitors as Amazon, though I imagine Amazon has more sessions per visitor, but the GMV across Shopify is just shy of half of Amazon. It's still in the same ball park.
tomnipotent··on OpenRouter is joining Stripe
That requires that you create accounts and separately manage each provider you want to use. OpenRouter removes that - if a new provider gets added, you can start using them immediately.
tomnipotent··on uBlock Origin Is Giving Up the Fight to Keep Ads Off Facebook
The further away you get from direct marketing where you can track conversions, and the further up the funnel you go, the less and less analytics help. Another way to think of it is that there are tranches of spend - the central tranche is easily attributable direct marketing but there's a limit to how much you can efficiently spend, but the further from the center you go the less effectively you can measure the efficacy of the spend but there are more options to absorb ad dollars.

Maybe 15 years ago multi-touch attribution was the big push but even that only adds minimal insights into how ad spend affects the behavior you're trying to measure. It helps with high-level channel attribution but it's still at best directional.

So once you reach a point when increasing spend at Meta/Google results in superlinear increases in CAC vs. spend, you eventually end up having to move those ad dollars elsewhere and over time (and a lot of money) you get an intuitive understanding of how these other mediums trickle down to the metrics that matter.

You're totally right about agencies and their perverse incentives and how that leads to sub-optimal spend allocation.

tomnipotent··on uBlock Origin Is Giving Up the Fight to Keep Ads Off Facebook
It doesn't matter if your personal interaction is negative if on the whole it's positive across a larger corpus of users. By and large this exposure tactic works more than not.
tomnipotent··on uBlock Origin Is Giving Up the Fight to Keep Ads Off Facebook
The teams spending the kind of money these ad networks care about are doing a lot of upper funnel brand marketing where exposure is more important than clicks and where conversions are expected to be much lower for this segment of spend.
tomnipotent··on TSON – A JSON superset with immutable, hash-pinned schemas
> I don't see a fit for APIs here

Baically protobuf, Cap’n Proto, msgpack, Avro, or every other serialization approach that versions schemas?

tomnipotent··on Making Postgres queues scale
> on tiny writes

Postgres doesn't do "tiny writes" - it writes whole pages multiple times on every update even if you're only changing 4 bytes, combined with even more writes later on when vacuuming tables. This is one of the reasons why the historical advice was to not build high-volume queues on top of Postgres and why "oh look another post about queues on Postgres" keeps soliciting comments like this.

tomnipotent··on Making Postgres queues scale
You can't tune your way out of this constraint. The heap table and MVCC implementation put a hard ceiling on what can be accomplished without reaching for another tool.
tomnipotent··on Making Postgres queues scale
> scales a very long way

This ignores the fine print. It scales a very long way under specific circumstances with specific workloads. The more write-heavy your workload the less eloquently Postgres scales.

For OpenAI's use case you could swap Postgres with MySQL and it would scale just as well.

tomnipotent··on Making Postgres queues scale
That post is about how Postgres doesn't scale for write-heavy workloads and that they had to move those workloads to Cosmos DB. For the rest of the remaining mostly-read workload they have a single primary with 50 read replicas.
tomnipotent··on Netflix employee fired for sharing personal details in retreat trust exercise
Did you miss that a company attorney acknowledged "the ketamine therapy issue has factored into the termination?"
tomnipotent··on Zig Creator Calls Spade a Spade, Anthropic Blows Smoke
> and I believe it was premeditated

So in other words you're just vibing conspiracy theories and will believe whatever makes you feel better.

The only example of thin skin I see is the character assassination attempts and petty attacks by the Zig team.

tomnipotent··on Zig Creator Calls Spade a Spade, Anthropic Blows Smoke
There's literally nothing in that post of substance, other than the fact the Zig community is obsessed with trying to "prove him wrong" or some other such nonsense. Jarred's responses have been composed and civil, while the Zig team has been petty and vindictive.
tomnipotent··on Zig Creator Calls Spade a Spade, Anthropic Blows Smoke
> perpetually offended snowflakes

This attitude is so precious to me - "Sorry guys, you can't criticize my criticism."

> What Bun did here is basically a sabotage of Zig's reputation

If Zig's reputation was so fragile that Bun migrating to Rust caused this kerfuffle, then Bun isn't the issue.

tomnipotent··on My thoughts on the Bun Rust rewrite
It this a joke? Your example of Jarred starting fights in public is announcing fork then pointing to a thread where he didn't even participate but rather where members of the Zig community are slinging mud?

> unrequested fork

No such thing exists.

tomnipotent··on My thoughts on the Bun Rust rewrite
> have public fights with the language maintainers

Can you point to even one such example?

tomnipotent··on My thoughts on the Bun Rust rewrite
Andrew decided to attack the person rather than ideas and positions. It's not a reflexive revulsion, it's an appropriately sized reaction to a blog post in poor taste.

> not having any morals

You don't agree with someone so you claim they have no morals. I don't have words for how stupid this is that anyone can so casually dehumanize someone over something so trivial.

tomnipotent··on My thoughts on the Bun Rust rewrite
What points? All I'm reading is just a collection of emotional ad-hominems.
tomnipotent··on TypeScript 7
No they haven't. It's been said time and time again that their teams were struggling with large JS code bases for Bing Maps and O365 web apps.
tomnipotent··on TypeScript 7
> You really should just not assume things

And yet you follow this up by making assumptions about the motivations behind TS. Anders has mentioned that TS was purely motivated by internal MS teams struggling with huge JS codebases, nothing to do with C# but clearly his work on other languages would have influenced how he approached designing the language.

tomnipotent··on Physical disc production ending in Jan 2028 for new games on PlayStation
You seem to lack a basic understanding of what a market is in the context of a monopoly, and you can't argue your way around a bad foundation.

> our argument is basically "the law says so".

That's the only argument that matters, because monopoly is a legal matter.

tomnipotent··on Microsoft fire idTech team at Id software
Of course not, but most folks poking at Microsoft are just borrowing their opinion from other people and regurgitating it for karma. I'm happy to crap on MS for bad decisions, but the constant "herp derp EEE" gets tired fast.
tomnipotent··on Physical disc production ending in Jan 2028 for new games on PlayStation
The Supreme Court ruled once on what they consider an aftermarket monopoly against Kodak in the 1990s, but the aftermarket angle on monopolies has been basically abandoned from a legal perspective because it was shaky at best.

Both iOS and Android both generate more in gaming revenue than Sony. The PC gaming market is only slightly smaller than the entirety of the console market. It's going to be very difficult to make an argument that customers don't have reasonable choice, and the recent case against Apple set precedent that owning the single channel of distribution to a product and platform you own isn't monopolistic unless you do shady things like Google did.

Sony's exclusive rights to distributing games on its owned platform and console will not give it pricing power (won't pass SNNIP) or exclude competition.

Sony can be called a dick for what they're doing without it also having to be monopolistic. People are right to be angry and calling them a monopoly over it is being cathartic.

tomnipotent··on Physical disc production ending in Jan 2028 for new games on PlayStation
> they now have total command of supply

They've always had control by licensing who can publish games on their platform. Now that contract with publishers has changed who can distribute. Publishers are still free to distribute on other platforms in whatever formats those platforms allow.

> that market being Playstation games

This is arbitrarily narrowing the definition of market as far as possible while ignoring reasonable (legal) thresholds. Case in point how Apple's App Store was not ruled a monopoly while Google's Play Store was - there are reasonable tests to pass, and Sony's case will land closer to Apple than Google. And a monopoly is not the only form of anti-competitive abuse.

Might as well claim Domino's has a monopoly on Domino's pizza.

← PreviousPage 2 of 34Next →