search

cockroachdb / docs

CockroachDB user documentation
https://cockroachlabs.com/docs
Creative Commons Attribution 4.0 International
188 stars 458 forks source link

Unclear best-practices advice on (de)normalization #8877

Open bobvawter opened 4 years ago

bobvawter commented 4 years ago

Bob Vawter (bobvawter) commented:

There's a bullet point in https://www.cockroachlabs.com/docs/stable/performance-best-practices-overview.html that seems counterintuitive when I read it:

Increase normalization of the data to place parts of the same records that are modified by different transactions in different tables. Note however that this is a double-edged sword, because denormalization can also increase performance by creating multiple copies of often-referenced data in separate ranges.

Should this say "Decrease normalization" or just "Denormalize the data"?

Jira Issue: DOC-538

lnhsingh commented 3 years ago

@rmloveland I think this is in your area but feel free to reroute if not.

github-actions[bot] commented 1 year ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB docs!