anarazel

62 ms·

631.
by anarazel 7y ago
They directly benefit from not reducing recidivism... Talk about a fucked up reward structure.
632.
by anarazel 7y ago
I would love it for development (I work from home on personal HW) - multi-socket NUMA machines behave differently enough that being able to continually see how in-development software versions behave. And I just find it less productive &#x2
633.
by anarazel 7y ago
> With the cloud, you can assume that the government has access to the encrypted database. If you have a strong password, it will take them longer to brute-force your database. We are talking about two governments here: the US government
634.
by anarazel 7y ago
Even without considering the full phrasing of the 2nd to be related to militias, there's still considerable room for regulation. If one actually reads Scalia's Heller opinion, it explicitly says that regulation, of gun posession
635.
by anarazel 7y ago
This type of data structure ought to have much better cache and branch prediction behaviour than most tree implementations.
636.
by anarazel 7y ago
Not anymore ;). Well, at least in the upcoming PG 12. https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit... commit 212fab9926b2f0f04b0187568e7124b70e8deee5 Author: Thomas Munro <tmunro@postgresql.org
637.
by anarazel 7y ago
> In PostgreSQL, schema changes are transactional. With a few exceptions (that refuse to run in an explicit transaction): E.g. {CREATE, DROP} DATABASE, {CREATE, DROP} TABLESPACE, {CREATE INDEX, DROP INDEX, REINDEX} CONCURRENTLY, REINDEX
638.
by anarazel 7y ago
> Comments: I find comments, outside of docstrings, a smell. Neither function/type/whatever names, nor unit tests document architecture, concurrent behaviour, locking, ... to a significant degree. For simpler stuff that's
639.
by anarazel 7y ago
Isn't part of the problem here the consequences of charging / jailing / sentencing / imprisoning people in the us? There largely is no rehabilitation / mental health support happening while imprisoned (with jails be
640.
by anarazel 7y ago
And also suspend pretty basic rights, and deal with all the outcomes from people being institutionalized for not so well meaning reasons?
641.
by anarazel 7y ago
Their sales/marketing teams are way too aggressive, IME. They cold called me on my private number, despite being on the do-not-call list. At several conferences they've the one booth one had to be careful to stay away from, lest o
642.
by anarazel 7y ago
The whole Dell related ownership structure is just ... odd. Under the terms of the transaction, Pivotal's Class A common stockholders will receive $15.00 per share cash for each share held, and Pivotal's Class B comm
643.
by anarazel 7y ago
Heh, that's one of mine. The point isn't so much to restate the if itself, it's to explain that we're explicitly testing before loading the JIT provider - which happens immediately below. Which in turn is because we a) d
644.
by anarazel 7y ago
> > TS is a very common abbreviation of timestamp. > Common != universal. It's known up until someone doesn't know it. We have pretty powerful autocompletes, let use them instead, or just lose 3 seconds writing the 10 le
645.
by anarazel 7y ago
It's like in any sizable codebase with quite some history. There's substantial difference in quality between parts. Some of the worst parts go back to the early days of postgres - the priorities and resources available back then
646.
by anarazel 7y ago
> It's a shame to see C++ gleefully going down this road, seemingly having finally drunk the Kool-Aid and adopted the myth that handling allocation failure to too difficult and too error prone; that it's not your problem and so
647.
by anarazel 7y ago
I unfortunately quite hate the direction of not being able to write conforming programs that handle out-of-memory in a way that's distinct from terminating. That's a great default for a large majority of systems, but e.g. for a
648.
by anarazel 7y ago
Might be worth retesting, we did some changes to PG to handle the unsupported syscalls more gracefully (warn once, and then not anymore) in a recent set of minor releases.
649.
by anarazel 7y ago
Thanks for the references! I personally work offline for a fair bit (personally more productive that way, and I'm also traveling plenty for work). So I kinda like the mbsync & maildir indirection (although I do hate the lack of NOT
650.
by anarazel 7y ago
Looks interesting! Based on a quick stroll through the source code, I don't see any search integration. Is that correct? I guess I could just shell out to notmuch? But I do find virtual folders for searches really convenient. Currently
651.
by anarazel 7y ago
For me (a nearly full time open source developer) the more technical conferences are a way to stay inspired, resolve /dissipate conflicts and try to figure out hard plans. I've yet to find anything that comes close, especially wit
652.
by anarazel 7y ago
Yes.
653.
by anarazel 7y ago
Well. You're going to run out of CPU and memory bandwidth pretty quickly. So you'd need replicas to share processing load. But I honestly don't think hundreds of users each querying 100s of GBs is all that common.
654.
by anarazel 7y ago
> I.e., if you are generating reports, running aggregations over a large amount of data you definitely need some parallelism and Postgres isn't designed to handle these loads (certainly not petabytes). Even aggregating 100's of
655.
by anarazel 7y ago
> Looking solely from a code perspective, how would this be done prior to Postgres 9.5 (before SKIP LOCKED)? It's possible to implement SKIP LOCKED in userland in PostgreSQL (using NOWAIT, which has been in PG), although it's o
656.
by anarazel 7y ago
There's several reasons for potential ordering changes: - the order of items on the page is different, due to the way tuples have been inserted (different external scheduling, different postgres internal scheduling) - concurrent sequen
657.
by anarazel 7y ago
> People do vary in their subjective valuation of a long commute. I probably do consider it to be less of a problem than most people. But do people really consider it to be worth nearly $2k-$3k a month? Yes. Two hours of commute every da
658.
by anarazel 7y ago
> The first section of the indictment describes the various ways in which Assange and/or Wikileaks said, more or less, "gee, it sure would be nice if someone got these classified documents for us." A lot of news orgs, and
659.
by anarazel 7y ago
The actual superseding indictment: https://www.justsecurity.org/wp-content/uploads/2019/05/Assa...
660.
by anarazel 7y ago
A few ms, with cold cache (both OS and postgres). The IN() roughly scales linearly with the number of elements, although it's often a bit better, as the upper tree levels are all in cache after the first few IN() element lookups.

More ›