Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
anarazel
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
35 ms
·
391.
▲
by
anarazel
5y ago
There's "implementation defined" for the concept you describe.
392.
▲
by
anarazel
5y ago
The situation has gotten at least somewhat better since then. Ubsan and friends are not a guarantee, but make it much more realistic to find UB issues.
393.
▲
by
anarazel
5y ago
What do you define as "bad"? Arguably several. I've seen cases of overflow checks that were implemented assuming signed overflow (which all relevant platforms implement!) getting optimized away. Correct, given "signed ov
394.
▲
by
anarazel
5y ago
> The union punning trick is UB in C89 and well-defined in C99 and later, although it was erroneously listed in the (non-normative) Annex listing UBs in C99 (removed by C11). Right, that's my point. If the standard folks can't
395.
▲
by
anarazel
5y ago
> For example, if signed integer overflow yielded an unspecified result rather than causing undefined behavior, I wonder if any implementations would be adversely affected. I suspect so - makes it harder to reason about loop counts becau
396.
▲
by
anarazel
5y ago
See e.g. https://github.com/postgres/postgres/blob/8bdd6f563aa2456de6...
397.
▲
by
anarazel
5y ago
Another thing is that the wording around some of the UB issues is just plain bad. The most extreme probably is the rules around strict aliasing. That there, for quite a while, was uncertainty whether the rules allow type punning by reading
398.
▲
by
anarazel
5y ago
> It's easy to pick on undefined behavior in C when you focus on the more gratuitous undefined behaviors such as signed overflow or oversized shifts. I wouldn't even mind the signed integer overflow thing that much if there wer
399.
▲
by
anarazel
5y ago
That kind of headphones really was a significant upgrade for me. Being able to listen to something while still having environmental awareness is awesome. I do wish the max volume for the aftershokz where higher, and they didn't have th
400.
▲
by
anarazel
5y ago
The drip tray is the most annoying about it for me. Lots of corners that are hard to clean, and occasionally some of the "waste" water from steam or coffee seems to end up besides it. Still very happy with it.
401.
▲
by
anarazel
5y ago
Many, if not most, people in that age group actually aren't yet fully vaccinated - the general availability was April 14th in SF. 21 days between vaccines plus two weeks of waiting. Plus a few days to find a slot maybe. So a few more d
402.
▲
by
anarazel
5y ago
I don't think that's really true. Which part of postgres would you describe as a KV store, compared to what cockroach does with RocksDB?
403.
▲
by
anarazel
5y ago
I suspect that in postgres'case that is just because a TODO list was moved out of the code...
404.
▲
by
anarazel
5y ago
Of course SF has a good hospital coverage, displaced a lot of poorer residents. Thus fewer people working high-risk jobs in SF actually end up counted in SF's stats. But I don't think that SF's 62 deaths/100k (compared t
405.
▲
by
anarazel
5y ago
SF fared a lot better than LA, which was a lot looser with restrictions...
406.
▲
by
anarazel
5y ago
Good point - it's still 22 other indexes though. And it's Aurora, so who knows :). The table is fairly large, so it's quite possible that a lot of the indexes aren't in memory, making the index maintenance more expensive
407.
▲
by
anarazel
5y ago
Gin indexes aren't "plain" indexes - they're used for things like full text search. Depending on the specific types/opclasses that can mean that a lot of work has to be done for a single inserted/updated row.
408.
▲
by
anarazel
5y ago
> Right there's no huge containment facility, but there's still a concrete dome over the reactor isn't there? I'm pretty sure these aren't intended to be used with a concrete dome or anything as substantial as t
409.
▲
by
anarazel
5y ago
Why huge amounts? These reactors are supposed to fit on a semi truck (see e.g. the articles "infographic").
410.
▲
by
anarazel
5y ago
We're talking microreactors here? There's no huge containment facility. They're not all that large.
411.
▲
by
anarazel
5y ago
> And now you have just cut a hole into a nuclear reactor that is ON and killed yourself (or triggered a whole bunch of safety features stopping the nuclear reaction and maybe not kill the attacker but for sure notified the authorities)
412.
▲
by
anarazel
5y ago
I think it'd be good to put the different tests on a more comparable footing. E.g. comparing results of different services on hosts with different network latency isn't that meaningful. And the actual queries should be something r
413.
▲
by
anarazel
5y ago
> However, if I use pipelining, I see 1000 lookups performed in 4.725ms (i.e 0.0047ms per lookup). To be clear, that's over a single connection, not a parallel test.
414.
▲
by
anarazel
5y ago
The biggest influence on small query performance for RDBMSs is server<->client latency. I just checked, and a single simple key-value style lookup in postgres over a local unix-socket connection takes 0.025ms on average. However, if I
415.
▲
by
anarazel
5y ago
It's interesting. I had to use mercurial for work at some point and I just could not get comfortable with it. I know several people that feel like me, and several that feel the same about git. I wonder what the difference leading to th
416.
▲
by
anarazel
5y ago
I regularly hack on a slightly larger feature, fix, whatever. Once it's working, I incrementally stage lines for the separate commits that'll make up something reviewable. Doing a line-by-line review of the change at the same time
417.
▲
by
anarazel
5y ago
My guess: Sending email to a lot of recipients when you're not a large email provider can end up with you getting throttled / needing to apply throttling to individual servers to prevent blocking. In the past when I still operated
418.
▲
by
anarazel
5y ago
Are there cases where a compiler reasonably would internally use a different calling convention that supports fewer arguments passed via register passing? Yours is still a valid point (no reason doesn't imply a guarantee) even if there
419.
▲
by
anarazel
5y ago
It seems like a model fairly vulnerable to a few people with resources suing? Both from a copyright and a defamation angle?
420.
▲
by
anarazel
5y ago
Fwiw, it's not too hard to approximate that in c/c++. Print out the pid (I often print out "gdb -p %d") and then sleep (and perhaps send SIGSTOP to other processes in more complicated scenarios).
More ›