Readit News logoReadit News
mikeklaas commented on On being tired   jukkaniiranen.com/2022/02... · Posted by u/kimmk
angarg12 · 3 years ago
I've spent the last couple of years at the two bottom levels of that scale. It took me an embarrassingly long time to realize one of the root causes: my wife and I have fundamentally different personalities that are at odds with each other.

My wife is an extrovert. She is energized by going out, visiting places, doing things, meeting people.

I'm an introvert. I get energized by staying in, reading a book, watching a movie, spending time by myself.

This creates tension every weekend when we need to negotiated what to do. This friction is weary by itself, but then the outcome almost always makes someone unhappy. Most weekends rather than recharging for the rest of the week, I end up more tired than I started.

Not sure how well this will generalize but if you find yourself in those bottom steps it's worth it to do some introspection and audit how you spend your time.

mikeklaas · 3 years ago
> Most weekends rather than recharging for the rest of the week, I end up more tired than I started.

As a parent, it's hard to remember that ending a weekend "recharged" is a common experience.

mikeklaas commented on Things to know about databases   architecturenotes.co/thin... · Posted by u/grech
xmprt · 4 years ago
I know Clickhouse uses MergeTrees which are different from B+trees. However it can't really be used as an RDBMS. It's especially bad at point reads.

https://en.wikipedia.org/wiki/Log-structured_merge-tree

mikeklaas · 4 years ago
There are projects that use LSMTs as the storage engine for RDBMS' (like RocksDB); I'm not sure it's accurate to say "they can't be use as an RDMBS".
mikeklaas commented on Oauth2 support for GMail   pmail.com/newsflash.htm... · Posted by u/edward
qwerty456127 · 4 years ago
I have one question in this regard: will I still be able to access my mail through my own script I myself wrote? I understand I will probably have to make some changes and click some things in GMail settings but is this still going to be possible or will I too have to "publish app" even if I only mean it for my own private usage?
mikeklaas · 4 years ago
Development apps are exempt from the requirement. (They are also limited to 100 accounts)
mikeklaas commented on Single dependency stacks   brandur.org/fragments/sin... · Posted by u/jeffreyrogers
RedShift1 · 4 years ago
Why? You can have multiple databases in one instance, running multiple pg instances seems counterproductive?
mikeklaas · 4 years ago
Multiple databases in postgres fundamentally share the same underlying infrastructure (i.e., WAL), and so do not offer much in terms of scalability or blast-radius protection compared to putting all tables in the same database.
mikeklaas commented on Ask HN: What are the best-designed things you've ever used?    · Posted by u/whitepoplar
jimmies · 4 years ago
Zorijushi rice cooker. It can cook rice perfectly and can hold cooked rice for days.

Facebook portal. Yeah Facebook privacy and all that but that's a good product that allows me to call people without having to mess with the phone. The audio and video is super clear. I use it despite it's from Facebook.

Work sharp knife sharpener. It's superior to sharpening the my knives with the stone.

Apple airtags. I often forget where I put my keychain so this is really well executed. Apple airpods. They just work and they are nice enough.

Hakko soldering station. I don't know if the recent Chinese usbc ones are better but the hakko one I have work well enough for everything I want to do.

mikeklaas · 4 years ago
I'm surprised to see the Portal listed. We have one for letting the grandparents talk to the kids, and it is the most unreliable piece of technology I've owned. Constant connection issues and laggy UI.
mikeklaas commented on Never update anything   blog.kronis.dev/articles/... · Posted by u/cesarb
Waterluvian · 4 years ago
AWS: “Postgres 9.6 is old. On January 22 we will forcibly update your instances to 12. We hope you noticed this alert. We certainly didn’t email you about this. You’d better get off your ass and test/fix your clients for any potential issues.”
mikeklaas · 4 years ago
whoa, do you have a link?
mikeklaas commented on When “Foundation” Gets the Blockbuster Treatment, Asimov’s Vision Gets Lost   newyorker.com/magazine/20... · Posted by u/DLay
ddoolin · 4 years ago
I only read "Foundation and Earth" before the show began (that's what was on hand where I was, I had little choice, as much as I hate starting in the middle of a series), and that book is VERY different from what I'm reading in the first book and what's in the TV series, and would indeed make for a pretty interesting show or at least a movie.

It's literally about three people's journey across the cosmos to discover the origin of humanity and really, very little of the original story re: Seldon comes into it. It makes me wonder what happens in between.

mikeklaas · 4 years ago
That's probably the worst book in the series.
mikeklaas commented on A read query can write to disk: a Postgres story   mutuallyhuman.com/blog/ho... · Posted by u/yakkomajuri
latch · 4 years ago
This is pretty basic PostgreSQL tuning (1). An oft-cited problem with PostgreSQL is that it uses a process-per-connection (session in PG lingo, I think). `work_mem` is the amount of memory a connection has to, you know, do work. Sorting, distinct, some joins.

Number of Connections * work_mem is usually going to eat up the biggest chunk of your PostgreSQL's memory. AFAIK, the configuration is extremely coarse. There's no way for example to say: I want all the connections from username "myapp" to have 10MB and those from user "reporting" to have 100MB. And it can't be adjusted on the fly, per query.

Being able to set aside 200GB of memory to be used, as needed, by all connections (maybe with _some_ limits to prevent an accident), would solve a lot of problems (and introduce a bunch of them, I know).

Since they're on RDS, I can't help but point out that I've seen DB queries on baremetal operate orders of magnitude faster. 10 minute to 1 second type thing. I couldn't help but wonder if they'd even notice the disk-based sorting on a proper (yes, I said it) setup.

(1) https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv...

mikeklaas · 4 years ago
> And it can't be adjusted on the fly, per query.

Sure it can:

   SET LOCAL work_mem = '256MB';
   SELECT * FROM …

mikeklaas commented on Roblox has been down for days and it’s not because of Chipotle   theverge.com/2021/10/30/2... · Posted by u/Terretta
jitl · 4 years ago
I wonder if they have a major Postgres database that hit transaction ID wraparound? Postgres uses int32 for transaction IDs, and IDs are only reclaimed by a vacuum maintenance process which can fall behind if the DB is under heavy write load. Other companies have been bitten by this before, eg Sentry in 2015 (https://blog.sentry.io/2015/07/23/transaction-id-wraparound-...). Depending on the size of the database, you could be down several days waiting for Postgres to clean things up.

Even though it’s a well documented issue with Postgres and you have an experienced team keeping an eye on it, a new write pattern could accelerate things into the danger zone quite quickly. At Notion we had a scary close call with this about a year ago that lead to us splitting a production DB over the weekend to avoid hard downtime.

Whatever the issue is, I’m wishing the engineers working on it all the best.

mikeklaas · 4 years ago
I find it pretty odd to speculate that they are experiencing a very specific failure mode of a particular database. Do you even know whether they use Postgres?
mikeklaas commented on 1 Year of Coinbase as a mission focused company   twitter.com/brian_armstro... · Posted by u/dsr12
mikeklaas · 4 years ago
Do you have a source for that?

u/mikeklaas

KarmaCake day1412April 14, 2010
About
Co-founder and (former) CTO of Zite. Now at Flipboard.

mike.klaas at gmail.com

View Original