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.

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

Let CitusDB invalidate pg_shard's shard interval cache #133

Open
jasonmp85 opened this issue Aug 13, 2015 · 0 comments
Open

Let CitusDB invalidate pg_shard's shard interval cache #133

jasonmp85 opened this issue Aug 13, 2015 · 0 comments

Comments

@jasonmp85
Copy link
Collaborator

pg_shard keeps a cache of shard interval metadata within each session which is never refreshed. Within pg_shard this is fine, since all shards are created up front: caching forever isn't wrong. But now that Citus integration is more full-fledged, we're noticing that things like appending new shards or rebalancing existing ones results in pg_shard operating using stale metadata.

We need to come up with some sort of contract to let other pieces of software tell pg_shard about changes in the shard intervals of a distributed table. We may be able to reuse some existing pieces of invalidation logic within PostgreSQL, but that requires some reading to determine.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant