rwultsch | 1 year ago | on: Why Canada Should Join the EU
rwultsch's comments
rwultsch | 1 year ago | on: Why Canada Should Join the EU
Oddly enough I am visiting Japan right now. There are lots of foreign workers in service jobs. They speak zone language and don’t jay walk.
Prices feel like a middle income country, but that is just the Yen sucking. Otherwise it feels very first world.
rwultsch | 1 year ago | on: Pattern of brain damage is pervasive in Navy SEALs who died by suicide
They are however incredibly loud. Being close to someone shooting 556 with a brake is a really annoying experience and I would not be shocked if there were follow on effects.
rwultsch | 1 year ago | on: First randomized trial of Ozempic for alcoholism shows big drops in drinking
I am an overweight person that drank more than I should. Ozempic helped me drop 15 lb and I don’t feel the draw of drink nearly as much as I had.
I was diagnosis ADHD as a kid. Since being on Ozempic I have noticed no difference in ability to hold attention.
rwultsch | 1 year ago | on: HBase Deprecation at Pinterest
“Introduced in 2013, HBase was Pinterest’s first NoSQL datastore.”
I don’t think this is correct. When I started in late 2013 Redis was being used as a persistent data store. And what pain it was. I convinced leadership in late 2014 this was a bad and they had me keep it alive until it was replaced by MySQL in mid 2015.
HBase was nothing but pain at Facebook where it was supposed to replace MySQL and then Pinterest where… I think there was hope it would replace MySQL. Once I automated MySQL at Pinterest I think it wasn’t so bad, particularly given the absurdly limited staff they gave the problem.
rwultsch | 2 years ago | on: Google to pause Gemini image generation of people after issues
I enjoy that “ma” has ambiguous meaning above. Does it mean mandarin question mark word or does possibly mean mother?
rwultsch | 2 years ago | on: How Pinterest scaled
A pin was a 1.2 KB json blob. There were other tables but pins was the big one. Why MySQL? It did not destroy data like the alternatives.
how storage became efficient https://medium.com/pinterest-engineering/evolving-mysql-comp... https://medium.com/pinterest-engineering/evolving-mysql-comp...
rwultsch | 2 years ago | on: How Pinterest scaled
Before I joined in late 2013, they had not known how to run schema change without downtime. Once we fixed the kernel the db’s were nearly completely untaxed in terms of performance. They did however need large instances due to disk usage.
rwultsch | 2 years ago | on: A fridge from 70 years ago has better features than the fridge I own now
I am getting a Sub-zero in a few weeks which is damn near the most expensive fridge. It does not have nice pull out shelves or the veggie compartments.
I expect the sealing and ethylene scrubbing will keep veggies fresh linger.
rwultsch | 3 years ago | on: Ask HN: How to find a small town to relocate for remote work?
We recently moved to Frederick, MD. Walking distance to the very lively downtown, inexpensive housing, close to an airport, yada, yada...
rwultsch | 4 years ago | on: Tell HN: I let my 6-year-old daughter design my website
OT: How is the tech scene in Taiwan?
My wife is from Taiwan. Every time we visit I am very sad to leave. We have thought about moving to Taipei.
rwultsch | 4 years ago | on: Junk – Mark Bittman’s History of Why We Eat Bad Food
And Taiwan.
rwultsch | 5 years ago | on: Why Uber Engineering Switched from Postgres to MySQL (2016)
FB had plenty of schema changes. I know, I wrote software to push them out. The important concepts for pushing schema at scale became part of Skeema.
rwultsch | 6 years ago | on: Bolsonaro fires health minister, calls to reopen economy
Taiwan.
rwultsch | 6 years ago | on: The sound of the Hagia Sophia, more than 500 years ago
Eh, I will kind of buy that. It was a church before it was a mosque and churches tend to have quite a bit more music than mosques.
The race war comment above seemed uncharitable.
rwultsch | 6 years ago | on: The sound of the Hagia Sophia, more than 500 years ago
The Hagia Sophia was the site of a significant massacre when it was forcibly converted from a church to a mosque.
rwultsch | 6 years ago | on: Command-line tools can be faster than a Hadoop cluster (2014)
I was on the DBA team there around that MAU. I had lots of company and support from SRO (aka jr DBA's) as well as other teams (provisioning, etc...).
rwultsch | 7 years ago | on: Facebook, Instagram go down around the world in an apparent outage
Short duration: network, bad software deploy
Long duration: db. If you break data, it takes a while to unbreak.
Source: Me. My career has been spent managing db's for internet scale sites.
rwultsch | 9 years ago | on: Reasons to choose PostgreSQL 9.6
Postgres has had CTE for a while, but not that long. MySQL 8.0 (the next version) plans to them http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-t...
rwultsch | 9 years ago | on: PostgreSQL 9.6 Released
You missed the point of my post. You are going to have one of the two issues, either looking through two index or indexes including the a large PK. At least with InnoDB you can make the choice. The strategy I suggested gets you the desired outcome of not including a large PK in all secondary indexes.
page 1
Also, a quick googling suggests both Poland and Japan both have fertility rates around 1.2. Working age of Poland is 65% of the population vs 60% for Japan. So a bit worse.