citusdata / citusdata/citus_docs

Document how to replicate reference tables to coordinator

Open
#1,053 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
CSS
Stars
58
Forks
60
PR merge metrics
No merged PRs in 30d

Description

Hi, we're preparing a POC to migrate an existing Postgres database to Citus for further scaling. We have a few tables we designated reference. They're also used together with many tables that will stay local to the coordinator. Some of the queries are very inefficient if they have to run in the distributed mode.

Therefore, I wondered why it wasn't possible to keep one reference table copy at the coordinator. I stumbled upon citusdata/citus#1615 and citusdata/citus#3155. Calling `master_add_node` indeed seems to solve our issues but I can't find any documentation about that function since v6. If I understand it correctly, it's an alias for `citus_add_node`, right?

It surprised me this behaviour of reference tables wasn't the default. Are there any drawbacks to calling `citus_add_node` with the coordinator address and `groupId => 0` apart from the reference tables storage requirements? It would be great if this use case was documented.

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the current documentation for master_add_node and citus_add_node, then read the referenced issues citusdata/citus#1615 and citusdata/citus#3155. Document how to replicate reference tables to the coordinator, including whether citus_add_node with groupId => 0 is the supported equivalent and what drawbacks apply.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases, documentation
Issue type
Documentation
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.