citus_docs
citus_docs copied to clipboard
Documentation for Citus. Distributed PostgreSQL as an extension.
## Communication goals (e.g. detailed howto vs orientation) Citus does not support adding foreign keys between local and distributed tables. It does support distributing the target table for an existing...
## Why are we implementing it? (sales eng) ### What are the typical use cases? * How can you run multiple Citus clusters at once? Samay can share more about...
It has some fancy `insert…select` statements, but no upserts. We want to show people how those can work for dealing with delayed data. https://docs.citusdata.com/en/v7.1/use_case_guide/real_time_dashboards.html
Review the common words that people use in our internal search bar, and see if the terms bring up the correct pages. If not, mix new phrases into the content...
## Communication goals (e.g. detailed howto vs orientation) The section is fairly dense and contains historical cruft. * "Table Distribution and Shards" is more like "Picking the best column for...
We still mention upgrading from citus 5.x here http://docs.citusdata.com/en/latest/develop/reference_ddl.html#upgrading-from-citus-5-x There is no way somebody could upgrade to citus 8.1 from 5.x directly.
we provide the code to follow in our references. In https://github.com/citusdata/citus_docs/blob/master/use_cases/realtime_analytics.rst Instead of providing the code to be copy/pasted we provided diff part. It is useful in terms of explaining...
Based on the [documentation](http://docs.citusdata.com/en/v7.5/develop/reference_sql.html) > Reference Tables can be used as “dimension” tables to join efficiently with large “fact” tables. However, it turns out that we can't outer join reference...
Rails app migration steps in docs has discrepancy in distribution key that's not present in example rails app. create_table :page_views, partition_key: :customer_id do |t| create_distributed_table :page_views, :account_id I believe that...
## Why are we implementing it? (sales eng) ### What are the typical use cases? ## Communication goals (e.g. detailed howto vs orientation) We have a section (http://docs.citusdata.com/en/v7.5/cloud/availability.html) which already...