3,979 karma · joined February 4, 2017
- Query planner is much worse (just yesterday I had to USE INDEX to sped up a query by 300x, I'm near-certain postgres would just have gotten it right) - Indexes are much more limited: no GIST, no GIN - No transactional lock (`pg_advisory_xact_lock` in postgres). This one was very surprising, it's a really useful thing and I had to implement it myself as a lock table
A bit of an extraordinary belief to hold, to be honest
Maybe because most (tech) things do make most people's live worse without fail (such as these glasses being available)? I don't see how you can blame people for a very rational reaction here
Who says that? Who is doing _anything_ for AI to result in (even non-extraordinary) improvements in prosperity for the average citizen? I'm hearing a lot about AI reducing need for human labour, but literally nothing about doing anything to transition into a post-labour society. Absolute madness.
So far it's all very standard (if scaled up) wealth concentration, and not even a pretense of it trickling down.
I don't think so, esp at selling time, I definitely expect that the owner has just made it look pristine. But the opposite is definitely true: if you can't even bother making it look clean and tidy when trying to sell, I'm pretty sure you've not taken care of it in the past!
that is indeed a roughly accurate definition of what "unidiomatic" means
Thinking that an actor in a system will go against the incentives of the system (at least at scale and over time) is naive.
If you're a SaaS, 1h of downtime costs a lot of money. In reputation, in lost business, in support time, in on-call response, in making a public postmortem and sharing it to customers and dealing with responses... For saving a few thousand bucks, it's often indeed a very bad deal.
> learn about GIN (and GIST) indexes
yes, but also learn about the trade-offs and in particular the "pending list". The flush of the pending list can be slow, causing timeout, causing the list to not be flushed, causing the next write to trigger flush again and failing in the same way, which means you're having downtime. The default pending list size is weirdly high IMO
If only for her being a singer, I don't see how she _wouldn't_ be a musician
I don't think that's true. I find that it way, way over-intensifies: eg using "load-bearing" for something that's just "kind of necessary although we probably could find a way without it". My personal gripe is how easily it uses "incredibly" or "wildly": just today it was telling me that something is "incredibly cheap" to mean that it's not over-priced ("cheap" would have been okay and even then, barely)
This HN thing of casually using acronyms without defining them is baffling to me
Your statement actually makes the way out of the spiral very explicit: Trump must stop being in power.