HNHacker News
TopNewBestAskShowJobs

shock-value

1,038 karma · joined August 22, 2010

submissionscomments
shock-value··on Tricking PostgreSQL into using an insane, but faster, query plan
I think SQL is generally great but I do agree with you. Access to lower level primitives from which one could construct their own query plan would be awesome. Query hints (not available in Postgres) would also probably get you a lot of the way there.
shock-value··on Tricking PostgreSQL into using an insane, but faster, query plan
It's basically shameful how the maintainers refuse to even entertain the thought of allowing query hints. These kinds of articles and anecdotes come up again and again, yet seemingly no movement whatsoever on the blanket ban on query hints in Postgres. (See https://wiki.postgresql.org/wiki/OptimizerHintsDiscussion)

Postgres generally is great -- so many great features and optimizations and more added all the time. But its query optimizer still messes up, often. It's absolutely not the engineering marvel some would have you believe.

shock-value··on Israel Finds Fourth Covid Booster Is Ineffective
> and in the case of the latest variant, we know they are not effective

I assume you are talking about stopping spread, which could be accurate. I further assume you are not referring to reducing illness severity, because they obviously are effective at that. But that benefit extends beyond the individual insofar as it reduces strain on the overall healthcare system -- ensuring that even those who have injuries or illnesses that have nothing to do with the disease in question receive adequate care. Therefore a vaccine mandate (or restrictions placed upon those who aren't vaccinated) can still be justified.

shock-value··on €2.6M spent for a book at auction, believed they would own the IP
A lot of nodes are run by some (relatively) well-known, well-funded companies. See https://ethereum.org/en/developers/docs/nodes-and-clients/no...

Wonder if they will be or have been subject to copyright complaints / lawsuits.

shock-value··on Netflix’s Prices Are Rising Faster Than Cable
Their major competitors already have functioning platforms of their own.
shock-value··on €2.6M spent for a book at auction, believed they would own the IP
A handful of words can be copyrightable. The idea of copyrighted content being stored on a blockchain that thousands of nodes duplicate and offer freely is an interesting conundrum that your reply entirely sidesteps. I’m guessing it has happened already but I too am interested in the legal implications of this.
shock-value··on The Matrix Is Unreal
At least some iterations of Gears of War do run at 30fps.
shock-value··on The Matrix Is Unreal
IMO 4k/60fps as a goal is overrated. 3k upscaled to 4k using a newer generation upscaler is not going to look much worse than native 4k, especially when viewed on a TV at a typical distance from one's couch. And 60fps, while crucial in some genres, is not altogether that important in others (particularly narrative-focused single-player titles, for which Unreal Engine is often used especially among non-major publishers).
shock-value··on Ubisoft’s first NFT plans make no sense
Maybe I'm misunderstanding but don't the fees scale (basically linearly) with the number of transactions? It seems like you are suggesting that this NFT based approach is superior at least in part because money can be invested/withdrawn more frequently/flexibly.
shock-value··on Ubisoft’s first NFT plans make no sense
Thus negating

> but you lose a lot of money on management fees that way.

(It's just not you paying the fees at this point in time.)

shock-value··on Debunking Cloudflare’s recent performance tests
It's pretty unprofessional.
shock-value··on TSMC “Apple-first” 3nm policy leads to AMD and Qualcomm mutiny
The equivalent of that (or more) is needed for a good VR experience.
shock-value··on Waymo will start testing self-driving cars in New York City
No. According to the press release the vehicles in NYC will all be manually controlled at all times.
shock-value··on Meta
Are you implying that their interest suggests that non-shit AR glasses will actually happen in the relatively short term? Big tech companies were and ostensibly are interested in self-driving too, and that seems to be taking much longer than they expected.
shock-value··on Wikimedia Enterprise: paid commercial product for reusing Wikipedia content
I don't know if this initiative includes Wikimedia Commons but I'm sure they've got substantially more data than that, and higher typical bandwidth usage.

(https://commons.wikimedia.org/wiki/Main_Page)

shock-value··on MTA tests new subway map that evokes jettisoned 1972 version
Using Central Park's geographic center as the common intersection point, the north-south distance between the park bounds isn't actually much longer than the east-west distance between the island bounds. (North-south and east-west according to the street grid alignment, that is.)
shock-value··on Southwest new CEO denies walk-off rumors, defends pilots amid schedule meltdown
That explains why the union would lie. Why does it explain why the airline would also cover (lie) for them?
shock-value··on GCP releases Spot VMs, the next generation of Pre-emptible VMs
"Horrific" is massive hyperbole, at least for my use case. (I actually use a GCP preemptible instance in this manner for a personal project, and spot instances will have the same shutoff risk.)

I edit application code on my (relatively underpowered) laptop, and automatically mirror it to the instance where the running services picks up any changes, and recompiles and relaunches as needed. It's a fairly chunky app code-wise so moving the CPU usage off of my laptop is very helpful.

When and if the instance shuts off early, I just relaunch it and reconnect. This amounts to one click of the mouse in the GCP UI, one locally run terminal command to connect, and one remote terminal command to (re)start my app. No work lost, and the cost savings are worth the minor inconvenience. Usually the instances last the full 24 hours anyway, and I usually shut it down when I'm done working, so interruptions are very rare.

I can understand that in the context of a larger company with more resources, a dev would be put off by this. But it works very well for my uses.

shock-value··on GCP releases Spot VMs, the next generation of Pre-emptible VMs
It's probably a niche use case, but there is some utility to having a guaranteed daily shutoff. For example, you might spin up an instance as an on-demand remote dev environment, and the 24 hour cutoff ensures it doesn't accidentally get left on (over a weekend, for example).

This would be easy to work around, but nonetheless could lead to unexpectedly high charges if you were relying on this behavior only to have it silently change.

shock-value··on Megatron-Turing NLG 530B, the World’s Largest Generative Language Model
Interesting, though as you noted it's less than 1/1000th the size of the 530B model and according to the article is only used in about one in ten U.S.-based English-language searches, at least when that was written.
shock-value··on Megatron-Turing NLG 530B, the World’s Largest Generative Language Model
Does that hold as the workload scales up? E.g. could this or similar models be used as part of a general-purpose search engine whereby (at least) one inference is completed per unique search? Aside from computation, I know these models consume an intense amount of memory -- would that scale horizontally easily / economically? Would it need to?
shock-value··on Clean environment could become U.N. human right
What you are describing falls under what I described in my last paragraph.
shock-value··on Clean environment could become U.N. human right
As in this case, the "right" to clean water (or any other exhaustible resource) makes no sense -- at least if described in such blunt terms.

Hypothetically, what happens in a drought, when there is no water for anyone? Have your rights been violated? If so, by whom?

If it's rather described as a right to nondiscrimination in the distribution of clean water (with respect to some set of properties, which could include wealth or ability to pay, but likely couldn't include large-scale geographic location due to distribution logistics), then that actually starts to make sense and can be realistically debated.

shock-value··on Clean environment could become U.N. human right
Yes that's also a "right" that is devoid of legal, moral, or practical meaning. As is any "right" to any exhaustible resource.

The UDHR is an aspirational document that has no legal force in and of itself.

shock-value··on Oculus will allow sideloading and rooting to avoid e-waste
Pretty questionable whether you should be letting a five year old use any VR headset. Oculus Quest specifies only ages 13+ and the science is definitely not settled as to how VR use would affect motor coordination development. If nothing else, the ergonomics really are not going to work for a child that young using any headset released to date (and I don't imagine any company sticking their neck out to release a targeted pre-teen headset anytime soon).
shock-value··on Alabama Had More Deaths Than Births in 2020
Scientific evidence, in this case that the vaccines are statistically effective and safe.
shock-value··on YOLOv5 on CPUs: Sparsifying to Achieve GPU-Level Performance
GCP lists a T4 which is suitable for inference for between $0.11/hour and $0.35/hour (depending on commitment duration and preemptibility).

https://cloud.google.com/compute/gpus-pricing

shock-value··on Unity patents ECS
Can you name a database that performs such a function? There might very well be one, but I'm not aware.

I'm most familiar with relational databases and the way in which their data is stored is generally dictated by the schema.

At a minimum, to be consistent with this patent we'd be talking about a database that accepts arbitrary groupings of predefined sets of fields, which then on-the-fly determines how best to pack these individual sets together with other sets belonging to other groupings. The fact that we are talking about two types of collections (one nested in the other) is key -- that is, the nesting of fields within the sets ("components" in ECS terminology), and the nesting of these sets within the groupings ("entities" in ECS terminology).

shock-value··on Unity patents ECS
Yeah I think it's a huge roadblock for Unreal. Though, I'm not sure that the patent would preclude a system which organizes memory layouts at build-time rather than runtime (though I could be wrong about that). Could be a good opening for Unreal, though to this point I think they've (disappointingly) shown little interest in any kind of ECS system.
shock-value··on Unity patents ECS
It's not relevant. Unity is claiming an automated system for determining an optimal memory layout as entities with new combinations of components are generated (at runtime). Such a layout defined in advance would not infringe.
← PreviousPage 3 of 12Next →