endymi0n

93 ms·

901.
by endymi0n 10y ago
This. I took a lot of inspiration doing this debugging session from my experience as a MySQL DBA. pg_catalog (PG) and information_schema (MySQL) are very similar indeed, and I remember finding out index sizes was even way easier in MySQL, t
902.
by endymi0n 10y ago
The dirty secret AWS doesn't want you to know is: Provisioned IOPS is really bad value for the money. Like a lot of others, we're just using a massively overprovisioned General purpose SSD volume, but reaching IOPS limits came bac
903.
by endymi0n 10y ago
Good catch, but what you're saying is at least what I was trying to convey. Still doing it like this would mean two potentially larger index lookups plus calculating the intersection between them rather than satisfying the filter from
904.
by endymi0n 10y ago
Now you make me cry :D Seriously, the hardest part for me about teaching and writing is going back and trying to see the problem from the eyes of the "guy you were before". Now that it's all obvious, it's suddenly all no
905.
Debugging PostgreSQL performance the hard way(justwatch.com)
359 points by endymi0n 10y ago|29 comments
906.
by endymi0n 10y ago
Exactly this, I was missing the big picture. Having worked with at least a dozen databases, my claim today is that of Tony Million: Don't be a hipster and just use Postgres. Don't get me wrong, I also work with Aerospike, Redshift
907.
by endymi0n 10y ago
No transactions? Single-threaded? Global lock? Don't want to put anyone's work down, but at first sight this looks much more like MyISAM than InnoDB - and just like this, MyISAM's a helluva lot faster than InnoDB for single w
908.
by endymi0n 10y ago
Telephoto was an interesting choice - in my day to day photographs though I'm rarely missing zoom capability that's not covered by digital zoom. What is missing though often enough is even better low-light capability. Honestly,
909.
by endymi0n 10y ago
Pianos actually often even employ a form of stretch tuning ( https://en.wikipedia.org/wiki/Stretched_tuning ) - which gets even more complex, as the OP only refers to sinus tones, which don't have any melodic over
910.
by endymi0n 10y ago
This. Ever heard of Myspace? Altavista? When making a market, watch out for well equipped and funded upstarts going to get you. Next victims of their own success: Docker.
911.
by endymi0n 10y ago
which is exactly what I meant with less specialized but safe :)
912.
by endymi0n 10y ago
On a related note, also the Go stdlib regex package is pretty naive and imperformant compared to a full blown and modern backtracking PCRE implementation (at 1/10 the LOC and complexity) - same thing goes for the reflection based JSON
913.
by endymi0n 10y ago
JustWatch (Berlin, Germany) is always out for smart, entrepreneurial thinking engineers (from INTERN to senior level) ONSITE, especially: - Backend Engineering (Golang, ElasticSearch, Postgres, Docker) - Web & hybrid Engineering (Javasc
914.
by endymi0n 10y ago
Well, I certainly wouldn't date a pine, even if it would make it 2000 years old. Pines are way too introverted for my taste.
915.
by endymi0n 10y ago
My thought exactly - the timing is really great in a way. - Skype gets worse with every release (especially Mac & Linux) and the call quality is still stuck in somewhere 2008 - Facetime is cool but still Apple Ecosystem only - Phone mes
916.
by endymi0n 10y ago
They need the camera (roll) "read" permissions for their screenshot protection.
917.
by endymi0n 10y ago
JustWatch (Berlin, Germany) is always out for smart, entrepreneurial thinking engineers (from INTERN to senior level) ONSITE, especially: - Backend Engineering (Golang, ElasticSearch, Postgres, Docker) - Web & hybrid Engineering (Javasc
918.
by endymi0n 10y ago
How to open a suitcase with just a pen, leaving no traces: https://www.youtube.com/watch?v=G5mvvZl6pLI "I love crypto; it tells me what part of the system not to bother attacking" - Drew Gross
919.
by endymi0n 10y ago
A little misleasing, as technically, this "motor" will not do anything to the satellite course - but just change its orientation. It's "only" a new spin (SCNR) on gyroscopes. Interesting nonetheless, even though mag
920.
by endymi0n 10y ago
Sounds like a lame-ass excuse for not even trying. Granted, if you're creating a market like Google or Facebook, it's hard to impossible. If you're doing the next AirBnB or Uber, it's pretty much on the table. If people
921.
by endymi0n 10y ago
Expensify: Making things more expensive. Certainly a fitting double meaning for a company which apparently had such a weak founder team that they had to replace hierarchy with anarchy - also known as "survival of the loud and smarmy&qu
922.
by endymi0n 10y ago
Now we're talking optimizing for a hugely multidimensional system here. Expressiveness: If you've aiming for a large team, try to work with a language that enables large scale services and large teams - also in the long run, stron
923.
by endymi0n 10y ago
The 50,000ft overview: Because you're surfing on the site, we can infer your movie taste. Now we're distilling that down anonymized on a user level and with the help of modern ad technology (the one where the shoe you already boug
924.
by endymi0n 10y ago
Let's say they pay our office space :) Seriously, the main reason we're outgrowing our competitors so fast is that audience marketing is a much more lucrative business than affiliate marketing. That way the site stays clean, the c
925.
by endymi0n 10y ago
514 days ago we launched JustWatch - https://www.justwatch.com https://news.ycombinator.com/item?id=9005641 By now, we're the largest streaming search engine in the world, having surpassed both canistream.i
926.
by endymi0n 10y ago
JustWatch (Berlin, Germany) is always out for smart, entrepreneurial thinking INTERNS & working students ONSITE, especially: - DevOps / Infrastructure engineering (Golang, AWS, ChatOps, Docker) - Backend Engineering (Golang, Elasti
927.
by endymi0n 10y ago
If you look at the continued sanctions against Russia, it's definitely possible. Never underestimate political demonstrations of power regardless of money involved, just remember the Berlin Air Lift...
928.
by endymi0n 10y ago
Are you missing something? Absolutely. Just to name a few: Deploys. Migrations. 3rd Party Systems. Configuration Rollouts. Failover not happening. Accidental failover. Rogue Employees. Routing changes. oh yes, Solar Flares too, but they&#x2
929.
by endymi0n 10y ago
Main problem is that Hollywood's media strategy is simply not reaching millenials anymore. Media consumption is split 60:40 on internet<>linear TV in the relevant target group, but media buying is split 40:60, quickly falling apa
930.
by endymi0n 10y ago
Clarifying my original reply here: UUIDs absolutely have their place - both the problems of distributed ID generation (mostly in remote clients / apps) and avoiding information leakage (-> German Tank Problem) are very real world ex

More ›