Open mgartner opened 8 months ago
Ryan Kuo (taroface) commented: Marcus Gartner Thank you for raising this! I’m not entirely familiar with this topic, but are the settings here relevant? https://github.com/cockroachdb/docs/blob/main/src/current/_includes/v24.1/misc/table-storage-parameters.md This table is included on the {{ALTER TABLE}} and {{WITH (storage parameter)}} docs (under the headings “Table storage parameters” and “Table parameters” respectively), and also has a link to a larger table of TTL storage parameters found here: https://www.cockroachlabs.com/docs/v24.1/row-level-ttl#ttl-storage-parameters .
Thanks for digging that up. It does look like ALTER TABLE
properly documents the storage parameters. I think CREATE TABLE
is lacking the same info though.
[This table] mentions storage parameters, but only in the context of "spatial index tuning parameters", not "table storage parameters" like ALTER TABLE
does.
Here's a CREATE TABLE
example:
CREATE TABLE t (k INT PRIMARY KEY) WITH (sql_stats_automatic_collection_enabled = false);
Marcus Gartner (mgartner) commented:
Searching the docs for "table settings" does not return relevant results. The only mentions of table settings that I've found are:
opt_with_storage_parameter_list
in theCREATE TABLE
docs, which only mention geo-spatial index options (which is incorrect in this context) and not table-level settings.I think we need a docs page dedicate to table-level settings that is searchable, explains what they are, how to set them on new and existing tables, and lists all possible table settings.
Jira Issue: DOC-9182