anarazel

31 ms·

271.
by anarazel 4y ago
> This should all just be a single boolean flag in the database config telling it to use huge pages which it gets from mmap dynamically. Why is any of the filesystem, permission, static allocation malarkey necessary? FWIW, those bits sho
272.
by anarazel 4y ago
I have had decent success using self crimped cables for 1gbit, but for 10gbit my success rate is way lower. Which makes sense, but has made me more hesitant to crimp myself.
273.
by anarazel 4y ago
My notification arrived minutes late, interestingly.
274.
by anarazel 4y ago
> Just some feedback for releases of any software: I think apt sources and repositories should be ready to go on launch and PR-release so people can immediately use the new version. Normally that's the case - we "wrap" the
275.
by anarazel 4y ago
Not normally, no. A real snapshot is held during the initial creation of the logical slot. After that the slot's "catalog xmin" prevents old catalog (but not user table!) row versions from being removed, but that's some
276.
by anarazel 4y ago
> You have a single DB running on a single machine. But you also care this much about write performance that you need sequential ids. How much longer is that single DB going to work for you, if write performance has become an issue? Pote
277.
by anarazel 4y ago
There's tasks where experience doesn't tell you ahead of time how long something takes. If you need to figure out a [novel take on an] algorithm, it'll be hard to predict the time even if you did things like that plenty times
278.
by anarazel 4y ago
It's not uncommon IME that doing the work to come up with a reasonable estimate is 80% of the final work. E.g., addressing a scalability issue might require a bunch of profiling work, then a bunch of experimentation / thinking abo
279.
by anarazel 4y ago
Vacuum does not have to read the full data set every time. The visibility map tracks, on a block level, whether all rows in a page are known to be visible to everyone (starting in 8.4 or such) and whether the page is "frozen", i.e
280.
by anarazel 4y ago
Requiring Google's CLA to be signed to contribute seems pretty limiting...
281.
by anarazel 4y ago
> I wonder whether you'd be willing to go into a meta-discussion on that, perhaps not public? I seem to hit this kind of stalemate too often and need someone's help to close the gap. I can see your email address in your profile
282.
by anarazel 4y ago
> Perhaps try to fully evaluate the idea rather than just shooting it down at the first perceived hurdle. I'm not trying to shoot improvements in this area down? I've spent time reviewing patches in the past, and I plan to do s
283.
by anarazel 4y ago
> People generally expect mature databases to have optimized any low-hanging fruit IME that's not true. I've been hacking on postgres, with occasional forays into other databases, for quite a while, and it's typically triv
284.
by anarazel 4y ago
> Also, note that Postgres already has features that are in the same area - null bitmaps put the null-ness of columns at the start of the row, and adding a ninth column moves all of the data in a row. It's all just implementation de
285.
by anarazel 4y ago
Both are significant. But the bit twiddling definitely shows up. There's some caching to avoid it in some situations, and breaking that causes measurable slowdowns. In the end it's not too surprising - a good number of columns fit
286.
by anarazel 4y ago
The problem is that we hear a lot of different features touted as "the crucial missing one"... Anyway, there's been work on this in the past, which recently has been picked up again. It's not all that trivial to do well
287.
by anarazel 4y ago
> And while it’s by far the most complex option, one of the nice bits with it would be that the system columns could be packed as well. Currently there’s quite a bit of waste because there are 6 system columns (by default), the first 5 a
288.
by anarazel 4y ago
Considering friends failures seems a bit more than differences. But I'd assume that's more a thing of quickly writing an HN comment than anything else.
289.
by anarazel 4y ago
I'd be more worried (but not terrified) that the session transcripts can teach an attacker a fair bit about how systems work, should an attacker get access to those. Of course only a small subset of attackers is going to care...
290.
by anarazel 4y ago
Those were under a law that applies to vaccines only, afaiu. And even there it's not an absolute immunity, just a much higher bar. "willful misconduct". See https://en.m.wikipedia.org/wiki/Public_Readines
291.
by anarazel 4y ago
At the very least it's a signal to hurriedly look for a new job, if not resign on the spot.
292.
by anarazel 4y ago
Street parking in most of SF requires a parking permit (which isn't free), you typically have to move the car weekly for street cleaning and in many areas of SF it's hard to find street parking.
293.
by anarazel 4y ago
Given the number of people I see that park their car on their property, without a roof or anything, I wonder if that neighbor has some pull in sf government...
294.
by anarazel 4y ago
I e.g. often check various code search tools to see whether it's worth maintaining a backward compat layer for APIs I'm in the process of changing.
295.
by anarazel 4y ago
You hit most of the same issues (and some additional ones) when compiling the same code within one translation unit...
296.
by anarazel 4y ago
IME there's plenty problems where nested locks will lead to a simpler solution than trying to avoid them. It's important to avoid when reasonably doable, but it's also not uncommon to take it too far and end up with a slower
297.
by anarazel 4y ago
Hm. Is it possible that that works better with multi-threaded than multi-process programs?
298.
by anarazel 4y ago
I've found that the scheduling quanta with chaos mode are too high to hit concurrency issues in a reasonable amount of time. And IIUC --num-cpu-ticks is not randomized. So if something happens below that tick quantum it's hard to
299.
by anarazel 4y ago
You made 10+ comments along those lines, just for this article. How about providing at least some justification, rather than making absolutist statements?
300.
by anarazel 4y ago
> Not only the implementation of qsort would have to be visible to the compiler, but also the implementation of the comparison function, which may be defined in a separately compiled module or passed around dynamically as a function poi

More ›