Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Improve metadata synchronization #26

Closed
jasonmp85 opened this issue Dec 9, 2014 · 1 comment · Fixed by #56
Closed

Improve metadata synchronization #26

jasonmp85 opened this issue Dec 9, 2014 · 1 comment · Fixed by #56
Assignees
@jasonmp85
Labels
citus integration feature
Milestone
v1.1

Comments

@jasonmp85
Copy link
Collaborator

Give Citus users a general UDF to sync pg_shard metadata with Citus catalogs.
@jasonmp85 jasonmp85 added this to the v1.1 milestone Dec 9, 2014
@ozgune
Copy link
Contributor

ozgune commented Jan 5, 2015

We could even break up this issue into two components.

  1. Generic UDF that syncs metadata from pg_shard to CitusDB: When a user creates a new pg_shard table, they can then call this UDF to sync table metadata. This enables users to get quickly started with CitusDB.
  2. Continuous metadata sync from pg_shard to CitusDB: In production, users will likely need their pg_shard metadata synced to CitusDB in real-time. Otherwise, Citus' Select queries may return stale results. One way to achieve real-time syncs is through triggers on metadata tables.

@jasonmp85 jasonmp85 assigned jasonmp85 and unassigned sumedhpathak Jan 19, 2015
@jasonmp85 jasonmp85 mentioned this issue Jan 20, 2015
Merged
jasonmp85 referenced this issue Jan 20, 2015
@jasonmp85
Merge pull request #56 from citusdata/feature-citus_integration-#26
c56862e 
Add function to sync metadata to CitusDB

cr: @sumedhpathak
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jasonmp85 jasonmp85

Labels
citus integration feature
Projects
None yet
Milestone
v1.1
Development

Successfully merging a pull request may close this issue.

Add function to sync metadata to CitusDB citusdata/pg_shard
3 participants
@jasonmp85 @ozgune @sumedhpathak