Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
srcreigh
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
26 ms
·
361.
▲
by
srcreigh
3y ago
The Bishops series by Fr Thomas Hopko on Ancient Faith radio is pretty good.
362.
▲
by
srcreigh
3y ago
I'm Eastern Orthodox, so trust me, I know. Did you know Istanbul is the same word as Constantinople? It's like a slang version. I'm probably talking to a Greek person, so I can't really say anything smart and not offend
363.
▲
by
srcreigh
3y ago
I'm ok with this re-writing. It would be confusing to call 800's Italy/France and 800's Turkey both "Roman Empire". We need different names for those places, even if the residents of the places used the same na
364.
▲
by
srcreigh
3y ago
One workplace I had used GCP. There was a Postgres upgrade and one of our services had a major performance degradation, some people worked for days to mitigate the problem. Sadly I don’t have the version number or any details as I wasn’t wo
365.
▲
by
srcreigh
3y ago
Waterloo Canada
366.
▲
by
srcreigh
3y ago
Same happened with me. Funny enough the other candidates solutions were shared on GitHub. Two funny aspects: 1. Other candidates were clearly spending 8-9 hours on the problem. I saw their commit logs. A commit every 1-2 hours for 9 hours.
367.
▲
by
srcreigh
3y ago
In my city office buildings are being converted to residential housing. 3 buildings recently in an area of population size 250k.
368.
▲
by
srcreigh
3y ago
The distribution of human temperature levels is already known, you could just give the average temp as every guess and get maybe 1.5 F average error. My point is, you can’t really get 0.44F avg error unless it’s predictive. The “std dev” of
369.
▲
by
srcreigh
3y ago
It’d be hard to get average error so low, since you need precision to get low error values for varying temps. You can’t just return 100 and -100 randomly, since the actual temp is unknown and you’d need to evenly sample around that.
370.
▲
by
srcreigh
3y ago
The alpha dev post claims 1.7% improvement on large sequences (250k+)
371.
▲
by
srcreigh
3y ago
Is it strange that it's slower in jart's testing but claimed to be faster in the AlphaDev blog post? jart doesn't provide detail about length of sequences used in testing, and AlphaDev basically says that between 6 and 249,99
372.
▲
by
srcreigh
3y ago
I like wooden log + <animal> ex bunny
373.
▲
by
srcreigh
3y ago
The table size optimization came from a wide keyed table with a single value as data. The proposed solution was simple (wide key, date, data). I showed that storing data as an array with start_date for indexing (one value per day in the arr
374.
▲
by
srcreigh
3y ago
UWaterloo CS grad. Want DBA work in query optimization/data layout, compiler related projects, other optimization related efforts, or try some devops (though I’m not as experienced with that) I’ve achieved 40x improved table storage si
375.
▲
by
srcreigh
3y ago
No better example of this than Racket. Function application itself is an overridable function. (f 1 2 3) compiles to something like (#%app f 1 2 3). And you can hook into that . Runtime type checking, stack traces, debuggers..
376.
▲
by
srcreigh
3y ago
Folks may also like goblin.tools https://goblin.tools/ Magic ToDo: Enter a task, click the magic wand button. It’ll expand the task into sub tasks. There’s also a (time) estimator to estimate how long task will take, tone g
377.
▲
by
srcreigh
3y ago
I don’t think that works for the self recursion trick. It’s a logical problem more than a representation problem. Even if you had a machine to decide halting status quickly, it’d be broken; representing computation as a graph can’t help. Th
378.
▲
by
srcreigh
3y ago
It’s not so simple, even finite halting code has to handle the self recursion reversal trick somehow. Aka the finite bounds must exclude the “if H(X,I) loop forever; else halt” code because H would still be broken. You could try defining H
379.
▲
by
srcreigh
3y ago
I can see why you puzzled over this. I’m not sure I agree with the guys argument — seems more like that there isn’t asymptotically better algorithm. It’s not convincing to me that there isn’t one division algorithm that’s a constant factor
380.
▲
by
srcreigh
3y ago
Can you share a story about this?
381.
▲
by
srcreigh
3y ago
The cause of this is the likely N+1-like behaviour of indexes on un-clustered data. Two options for speeding this up a ton (they dont' make sense to use together), 1. Cluster your data using the Gist/r-tree index. postgis docs [1]
382.
▲
by
srcreigh
3y ago
That's what I'm going for! I love this type of info, so against the grain and useful it's basically a scandal. :-) Check out your sibling comment about pg_repack though, it's a really awesome PG perf improvement tool.
383.
▲
by
srcreigh
3y ago
Thanks. I actually thought of similar pg_repack concept on my own a couple days ago (influenced by gh-ost probably..) I was googling stuff like how to switch a PG replica to master. I was imagining having 2 dbs and running CLUSTER on the in
384.
▲
by
srcreigh
3y ago
This site breaks the back button on mobile. It inserts a page to the stack, and it seems under certain conditions that page breaks the link back to this thread. It happened to me after reading the entire article, but not when I tried withou
385.
▲
by
srcreigh
3y ago
This isn’t really what tends to happen in meetings ime. Usually the problem is well understood and the meetings are spent with architecture types micromanaging the implementation of the solution.
386.
▲
by
srcreigh
3y ago
Nope, I read the article. Wonder if anybody uses k8s to migrate a monolith between different sized vms based on load
387.
▲
by
srcreigh
3y ago
Anybody have experience with k8s dynamically scaling up?
388.
▲
by
srcreigh
3y ago
Not a continuous function
389.
▲
by
srcreigh
3y ago
https://en.m.wikipedia.org/wiki/Nominative_determinism “Nominative determinism is the hypothesis that people tend to gravitate towards areas of work that fit their names.”
390.
▲
by
srcreigh
3y ago
Imo mysql is decent enough for many years, and PG has relatively major outstanding architecture problem (see my Other comment in this thread) I don’t think either DB is bad, but the whole MySQL is dead and needs serious work idea doesn’t ma
More ›