citus_docs
citus_docs copied to clipboard
citusdata
Documentation for Citus. Distributed PostgreSQL as an extension.
The last query lacks this where clause `AND ads.campaign_id = campaigns.id` ``` SELECT campaigns.id, campaigns.name, campaigns.monthly_budget, sum(impressions_count) as total_impressions, sum(clicks_count) as total_clicks FROM ads, campaigns WHERE ads.company_id = campaigns.company_id AND...
## Why are we implementing it? (sales eng) ### What are the typical use cases? Improvements that were added: 1. Fix several EXPLAIN ANALYZE issues that was caused by executing...
http://docs.citusdata.com/en/v9.1/use_cases/multi_tenant.html#scaling-hardware-resources Convert the Cloud mention to Hyperscale, with a corresponding screenshot.
## Communication goals (e.g. detailed howto vs orientation) Alert people in case they rely on pg semantics for their CTEs. ### Good locations for content in docs structure Add a...
I think doing `sqrt((sum(power(value, 2)) - count(value)*power(avg(value),2)) / (count(value)-1))` instead of stddev(value) should work ## Why are we implementing it? (sales eng) STDDEV doesn't work out of the box. The...
## Why are we implementing it? (sales eng) ### What are the typical use cases? ## Communication goals (e.g. detailed howto vs orientation) ### Good locations for content in docs...
## Communication goals (e.g. detailed howto vs orientation) We received a question in Slack where someone wants to know, "why use colocate_with in a situation where the default colocation group...
Currently, master_disable_node docs describe it as: ``` The master_disable_node function is the opposite of master_activate_node. It marks a node as inactive in the Citus metadata table pg_dist_node, removing it from...
Within our upgrade documentation we stated 'stop old or new servers' as the third step. If we run the new server before running the pg_upgrade, distributed deadlock daemon also starts....
Add canonical links in the 5.x version of the docs tutorials pointing at the new version. The "see latest version" link breaks there because the URL has changed. The canonical...