search

cockroachdb / docs

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

Low Latency Reads and Writes in a Multi-Region Cluster Doc Update #11786

Closed hand-crdb closed 3 years ago

hand-crdb commented 3 years ago

Re: Low Latency Reads and Writes in a Multi-Region Cluster

Issue Description

Contradicting table locality patterns are recommended at different places in the same web page.

At one place it says (my emphasis):

All of the tables except promo_codes have a composite primary key of city and id, in that order. This means that the rows in these tables are ordered by their geography. These tables are read from and written to very frequently. To keep read and write latency low, you'll use the Regional table locality pattern for these tables.

Later it says:

All of the tables except promo_codes are geographically specific, and updated very frequently. For these tables, the right table locality for optimizing access to their data is REGIONAL BY ROW.

Suggested Resolution

Change the first reference to match the second one, which is correct. So change the first one to:

All of the tables except promo_codes have a composite primary key of city and id, in that order. This means that the rows in these tables are ordered by their geography. These tables are read from and written to very frequently. To keep read and write latency low, you'll use the REGIONAL BY ROW table locality pattern for these tables.

jseldess commented 3 years ago

@rmloveland, PTAL.

rmloveland commented 3 years ago

Thanks @hand-crdb !!! Just merged your suggested change