anarazel

28 ms·

301.
by anarazel 5y ago
The weirdest part for me is that there is no reliable way to tell if the crossing street also has a stop sign (at least in CA). After 5 years of living in the US I still get annoyed about it.
302.
by anarazel 5y ago
ISTM the fairly obvious approach would be to bring up a complete copy of the affected database(s) and move the affected tenants to that "copy", while eventually deleting non-affected tenants. Can't imagine they don't hav
303.
by anarazel 5y ago
Spent fuel tank cooling not working isn't fun either. That needs power too.
304.
by anarazel 5y ago
Server isn't too far off...
305.
by anarazel 5y ago
> Reviewers: don’t read every line of code like you’re the lone avenger standing against all the “bad code,” in the world. I think what degree of review is relevant depends heavily on the area of code. In a core piece of something compli
306.
by anarazel 5y ago
The move to renewables in Germany slowed down drastically since the mid 2010s. Largely due to bad policy, not cost development. In German, but look e.g. at the third graph in https://www.wind-energie.de/themen/zahlen-un
307.
by anarazel 5y ago
When I read the title, I was assuming it was going to be about worsened code generation when building with exception support. Not about, basically, throwing exceptions as fast as possible. That seems an odd concern given the current perform
308.
by anarazel 5y ago
Is it really the distributed aspect? Or "just" working on a above average complicated project for many years? The consequences of bugs in many distributed systems (and several other types of systems) are IME often harder to bear t
309.
by anarazel 5y ago
I twice got things as part of an Amazon order what I didn't order. It took hours, and speaking so several supervisors to get them to take back the extra stuff, and that no, I wouldn't "just keep" large metal pipes.
310.
by anarazel 5y ago
What do you mean with postgres only supporting LATIN1?
311.
by anarazel 5y ago
The noise level of some US trucks still surprises me. Jet engine like.
312.
by anarazel 5y ago
It would likely have to be more than one hop, yes...
313.
by anarazel 5y ago
That's within the feasible distance for a point to point wireless bridge. If geography permits - which is not that likely. Not cheap, but might be better than alternatives.
314.
by anarazel 5y ago
I find the recommendations rarely useful. But what really bugs me is that the same series / movie typically shows up in all kinds of lists. Over and over and over. Besides the categories - often filled with stuff not matching the label
315.
by anarazel 5y ago
Just don't forget to budget for the increased fuel consumption for heating that water :). No experience around that, personally, ahem.
316.
by anarazel 5y ago
The criticality score in the referenced post about critical projects [1], the resulting projects [2] and the the "combined" list of various other sources of critical projects [3][4] all don't seem particularly on-point to me.
317.
by anarazel 5y ago
Depends on the purpose. E.g. for military uses like ICBMs they're quite important...
318.
by anarazel 5y ago
> The impression I got was that there are no paid core developers for PostgreSQL, is that correct? There are (I and several of my colleagues, for example) - but they're paid by employers having us work on postgres, rather than a fou
319.
by anarazel 5y ago
Apparently it takes about 100 days for the instruments to cool down far enough. https://planet4589.org/space/misc/webb/time.html
320.
by anarazel 5y ago
Random, low confidence and trollish, theory: Compiz et al had the opposite effect. The number of different compositor / effect projects increased the already substantial fragmentation of the linux desktop world, and put a large amount
321.
by anarazel 5y ago
Isn't that just because -1 is treated as a negative match? Which you then also request as a match?
322.
by anarazel 5y ago
I see such effects somewhat regularly, albeit not at an overall impact of 40%. With precise code layout having the biggest impact, leading to different L1i and iTLB hit ratios. Of course that requires execution costs to be well spread aroun
323.
by anarazel 5y ago
Perf c2c is extremely useful. Especially when using it with call graphs. Seeing which call stack interacts how with a cache line can make it a lot easier to find solutions to contended cache lines.
324.
by anarazel 5y ago
Some logic to exclude duplicate results would be useful. I often search to see how many external users there are of some API in postgres. But there's hundreds of separate repos with similar contents showing up in the search results...
325.
by anarazel 5y ago
Multiple cores make that a lot less ridiculous... And tend to easily be usable do accelerate compilation and running parallel tests.
326.
by anarazel 5y ago
IME icache misses are a frequent bottleneck. There's plenty code where all the time is spent in one tight inner loop and thus the icache is not a constraint, but there's also a lot of cases with a much flatter profile. Where icach
327.
by anarazel 5y ago
FWIW, a good chunk of the snapshot scalability changes are in PG 14, so the situation has gone a bit further towards s/processes/threads/ being the primary bottleneck. It depends quite a bit on whether you're write-mostl
328.
by anarazel 5y ago
(Although the sibling post pointing to my postgres connection scalability post is right - processes are not the major bottleneck at the moment, and certainly not with < PG 14)
329.
by anarazel 5y ago
> You can easily have many hundreds of thousands of processes, they are mostly equivalent to threads on Linux anyway (with some minor differences ofc). Not really. The page-table overhead of a 100k processes alone is going to a eat up a
330.
by anarazel 5y ago
I do not get why it's a good idea for a connection pooler to go for a process model. The whole "isolation and stability" argument is doubtful for postgres itself, but it's imo pretty much nonsensical for a pooler.

More ›