Ask HN: What engineering trivia earned you the most cred

5 pointsporkbrain10mo ago4 comments

Is there a specific piece of engineering knowledge that powered you to substantially contribute?

A software engineering example: knowing that Postgres FK doesn't implicitly create an index. Three different projects I joined weren't aware of this and we managed to improve the performance with a negligible amount of effort.

Keen to hear your wins (and make them mine ^^

4 comments

deanmoriarty10mo ago

Every time I start doing some network packet-based troubleshooting, for example firing up tcpdump to debug a tcp window size improperly tuned that caused a performance degradation over a high latency link (this is a random example I did last week), coworkers look at me like I pulled off some sort of wizardry. I feel it’s knowledge that most SWEs working on distributed systems should have acquired early and routinely use, but clearly that’s not the case.

austin-cheney10mo ago

Deeper internal knowledge of WebSockets and HTTP got me my current job.

catlover7610mo ago

> knowing that Postgres FK doesn't implicitly create an index.

Damn really lol

What does it do then, just block "breaking" deletes?

porkbrainOP10mo ago

You can cascade the deletes in db layer rather than in app layer

1 more reply

j / k navigate · click thread line to collapse