computer napkins (@computernapkins) 's Twitter Profile
computer napkins

@computernapkins

A newsletter about using napkin math and first-principle thinking to estimate systems performance: sirupsen.com/napkin/ by @sirupsen

ID: 1224700931624796161

linkhttp://napkin.computer calendar_today04-02-2020 14:27:29

15 Tweet

745 Followers

2 Following

computer napkins (@computernapkins) 's Twitter Profile Photo

The fifth problem was released yesterday! It's about databases, paging, and the importance of good primary keys. sirupsen.com/napkin/problem…

The fifth problem was released yesterday! It's about databases, paging, and the importance of good primary keys. sirupsen.com/napkin/problem…
computer napkins (@computernapkins) 's Twitter Profile Photo

The 7th Napkin Problem is live! This one's about ballpark figures for implementing revision history. sirupsen.com/napkin/problem…

The 7th Napkin Problem is live! This one's about ballpark figures for implementing revision history.

sirupsen.com/napkin/problem…
computer napkins (@computernapkins) 's Twitter Profile Photo

Another napkin problem published! Included is my answer to the last problem on storing revision history in a relational database. This week's problem is about syncing! sirupsen.com/napkin/problem…

Another napkin problem published! Included is my answer to the last problem on storing revision history in a relational database. This week's problem is about syncing!

sirupsen.com/napkin/problem…
computer napkins (@computernapkins) 's Twitter Profile Photo

9th problem is live. Also includes a detailed answer to problem 8: how to do Merkle tree based syncing! sirupsen.com/napkin/problem…

computer napkins (@computernapkins) 's Twitter Profile Photo

Another edition out, this time looking at whether MySQL transactions per second = fsyncs per second. sirupsen.com/napkin/problem…

computer napkins (@computernapkins) 's Twitter Profile Photo

This month's napkin math is about circuit breakers. If you've put one in production, I can almost guarantee you that you've configured it wrong. Read this edition to learn how to configure your circuit breaker correctly. 🧯 sirupsen.com/napkin/problem…

computer napkins (@computernapkins) 's Twitter Profile Photo

This edition is about filtering with inverted indexes. E.g. answering queries fast across millions of products of the type "give me all products that are blue, tagged summer, and are sneakers." sirupsen.com/napkin/problem…

computer napkins (@computernapkins) 's Twitter Profile Photo

Issue 14 is out! If you've ever tried to sync databases at scale, you know dropping records on the floor is inevitable. Here we tackle how to verify whether 100M+ records is synced with checksums in less than a minute. sirupsen.com/napkin/problem…

Issue 14 is out!

If you've ever tried to sync databases at scale, you know dropping records on the floor is inevitable. Here we tackle how to verify whether 100M+ records is synced with checksums in less than a minute.

sirupsen.com/napkin/problem…
computer napkins (@computernapkins) 's Twitter Profile Photo

Another edition just went out: Increase Performance by Fitting In the Initial TCP Slow Start Window sirupsen.com/napkin/problem…

Another edition just went out: Increase Performance by Fitting In the Initial TCP Slow Start Window
sirupsen.com/napkin/problem…
Simon Eskildsen (@sirupsen) 's Twitter Profile Photo

New Napkin Math out! Composite Indexes are about ~10x faster than index merges in Postgres and MySQL The gap between MySQL and Postgres' can be significant because Postgres doesn't support index-only scans when doing an index merge sirupsen.com/index-merges

New Napkin Math out!

Composite Indexes are about ~10x faster than index merges in Postgres and MySQL

The gap between MySQL and Postgres' can be significant because Postgres doesn't support index-only scans when doing an index merge

sirupsen.com/index-merges