Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Sesse__
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
43 ms
·
721.
▲
by
Sesse__
3y ago
We can do a rough estimate. There are (_very_) roughly half as many squares in 6x6 as there are in 8x8. This means that for every piece you add, you can expect (again very roughly) a 50% bonus to your branching factor. Now look at the best
722.
▲
by
Sesse__
3y ago
We definitely know for sure this was inserted intentionally. What we don't know for sure is whether Jia Tan (whoever that might be, if it is even a single person) did it on purpose, or if they had their account compromised.
723.
▲
by
Sesse__
3y ago
> I would not have risked my business (or budget) on Postgres 8, even with Slony-I. This assumes you need replication, though. You can get pretty far without it, especially given how wide hardware you can get now. > MySQL foot guns we
724.
▲
by
Sesse__
3y ago
Sure, there are improvements, but it's not like Postgres was a radically different beast back then. Would I pick Postgres 15 over Postgres 8? Yes, any day of the week. But I would also readily pick Postgres 8 over most of today's
725.
▲
by
Sesse__
3y ago
I'm sure user-defined structs can benefit from combining information from multiple functions, but saying that what you get today is “basically none” is a bit of an overstatement. Also, the special (and important!) case of operating sys
726.
▲
by
Sesse__
3y ago
> Other key topic: data structures. When reversing I spend half of the time renaming things and half of the time detecting data structures. The help I get from decompilers in latter is basically none. That's funny, because I've
727.
▲
by
Sesse__
3y ago
Extensions and stored procedures are not; they've been around for longer. I do not actually use any of the others you listed (well, occasionally bitmap index scans, but it's not a killer). The main difference between 8.x and 15.x
728.
▲
by
Sesse__
3y ago
As I understand the proposal, everything about visited link colors, for instance. Lots of cross-origin leaks. New forms of image leaks.
729.
▲
by
Sesse__
3y ago
I don't decide WPT policies (and I honestly don't know who does), but I'm pretty sure using a build script would be right out, as WPT is deeply embedded in a lot of other projects. E.g., if you made a build script, you would
730.
▲
by
Sesse__
3y ago
Yes, a _lot_ of WPT tests depend on <script>. But there's also a bunch of ref-tests, where you just check that A and B match pixel for pixel (where B is typically written in the most obvious, dumb way possible). It lets you test
731.
▲
by
Sesse__
3y ago
Opera switched from Presto to Blink, too. Very fun project! Did you ever consider integrating with web-platform-tests? It's shared between all the common browser vendors, and we're always interested in more contributors :-)
732.
▲
by
Sesse__
3y ago
The security implications would be interesting, unless you tainted the canvas (which makes it instantly less useful).
733.
▲
by
Sesse__
3y ago
> After a few of those it's just "it's a little bit slow everywhere". And after that, you need fine-grained profiling to find multiple 1% wins and apply them repeatedly. (I do this for a living, basically)
734.
▲
by
Sesse__
3y ago
I assume you're talking about the “nondistro build”? The difference between -g (--call-graph fp) and --call-graph dwarf is large even with perf linked directly against binutils, at least in my experience (and it was much, much worse un
735.
▲
by
Sesse__
3y ago
A typical case would be C++ virtual member functions. (They can sometimes be devirtualized, or speculatively partially devirtualized, using LTO+PGO, but there are lots of legitimate cases where they cannot.)
736.
▲
by
Sesse__
3y ago
It should also be said that you need some sort of DWARF-like information to understand inlining. If I have a function A that inlines B that in turn inlines C, I'd often like to understand that C takes a bunch of time, and with frame po
737.
▲
by
Sesse__
3y ago
Ah, of course, not only does it require O(n²) work to multiply, but n grows to n² for each iteration (n bits -> 2n bits). So that's why you get O(2^n) _total_ time.
738.
▲
by
Sesse__
3y ago
Fractint is fixed-point, not exact rationals.
739.
▲
by
Sesse__
3y ago
The RFC ostensibly covers the server protocol too, but as-is, there are tons of extensions to make things actually work well (e.g. what happens on rejoin after a netsplit). It's a bit sad IRC servers are no longer all the rage, because
740.
▲
by
Sesse__
3y ago
For Mandelbrot, presumably you can do exact rational arithmetic (all it needs is multiplications and add, and you presumably start with a floating-point coordinate, which is eminently rational). It will be very slow with many iterations, of
741.
▲
by
Sesse__
3y ago
I've worked on both an RDBMS optimizer and a CSS engine, and while the comparison is interesting, it's also not quite right. In particular, you can write pretty crappy CSS and it will work quite alright, including in all major bro
742.
▲
by
Sesse__
3y ago
I cannot speak for Firefox or WebKit, but at least in Chromium, these are going to be pretty much identical. Both are going to be bucketed based on the class (i.e., would only be considered for an element with class="cls", based o
743.
▲
by
Sesse__
3y ago
Explains why I found it so incredibly faux-deep…
744.
▲
by
Sesse__
3y ago
I ran DriveSpace on an 8088. For several years. Was too young to notice the slowness, I guess.
745.
▲
by
Sesse__
3y ago
apt doesn't use a SAT solver; it has its own heuristics. (Seemingly it _can_ call out to an external one if you give the --solver argument, which in 20+ years of Debian I have never seen anyone use, and which I didn't know of befo
746.
▲
by
Sesse__
3y ago
Seemingly also the Wikipedia article ( https://en.wikipedia.org/wiki/Ultraviolet_catastrophe ) claims the pop-sci ordering: “As the theory diverged from empirical observations when these frequencies reached the ultraviol
747.
▲
by
Sesse__
3y ago
Is there _any_ usable profiler on macOS? I've found Instruments to be straight-up useless (very slow, frequently gives just plain wrong results on larger projects) and pretty much every search I've tried just gives “use Instrument
748.
▲
by
Sesse__
3y ago
That's the sad side. The flipside is that for the employers that _do_ care, being able to use a profiler and repeatedly identify optimizations is considered some sort of superpower that very few of your coworkers possess. :-)
749.
▲
by
Sesse__
3y ago
OK, so basically ad-hoc/greedy. That can get you into, well, issues :-) There are methods where you first adjust away impossible statistics (if you have quals a,b, then P(a)P(b) >= P(a AND b), but if your estimates come from multipl
750.
▲
by
Sesse__
3y ago
Yeah, I don't have all the answers, my point is that it would be worthwhile to try similarly dumb stuff and see if it works just as well and could be more robust in some places :-) Multi-selectivities are good, but IIRC they can't
More ›