HN Explorer

Ask HN: What engineering trivia earned you the most cred

5 points by porkbrain ↗ HN
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 ^^

5 comments

[ 3.7 ms ] story [ 20.2 ms ] thread
catlover76
> knowing that Postgres FK doesn't implicitly create an index.

Damn really lol

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

porkbrain
You can cascade the deletes in db layer rather than in app layer
austin-cheney
Deeper internal knowledge of WebSockets and HTTP got me my current job.
deanmoriarty
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.