4 ms·
What are some examples of fine-tuning or trial-and-error you might need at scale?
by phendrenad2 4y ago
What are some examples of fine-tuning or trial-and-error you might need at scale?
- superb-owl 4y agoPostgres has a ton of parameters that can greatly affect performance. I've used https://pgtune.leopard.in.ua/ https://pgtune.leopard.in.ua/ to help w/ that. In terms of schemas, where you put your indexes matters a TON. Indexes make reads faster and writes slower (to oversimplify). Figuring out where to break out a separate table vs keep everything in one table is also a common issue.
- phendrenad2 4y agoTrue, all of these would still be an issue with ORMs.