citus_docs
citus_docs copied to clipboard
citusdata
PG 11 partitioning support
Why are we implementing it? (sales eng)
What are the typical use cases?
Communication goals (e.g. detailed howto vs orientation)
What features do we also support in citus? One in particular Samay mentioned is having unique indices in a parent table for use with upserts.
Good locations for content in docs structure
How does this work? (devs)
Example sql
Corner cases, gotchas
Are there relevant blog posts or outside documentation about the concept/feature?
https://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_11_New_Features_beta1_en_20180525-1.pdf
Link to relevant commits and regression tests if applicable
Just FYI:
PostgreSQL 11 adds support for foreign keys for partitioned tables. In Citus 8.0, we have two issues/limitations with foreign keys from partitioned tables.
The first one is related with Citus MX: https://github.com/citusdata/citus/issues/2406 The other one is related with Online rebalancer when a partitioned table have a foreign key to a reference table: https://github.com/citusdata/citus-enterprise/issues/284
Do we want to capture the limitations in the docs?
Yep, we should capture any limitations in the Docs as well.
Thanks!
On Fri, Oct 19, 2018 at 12:31 AM Önder Kalacı [email protected] wrote:
Just FYI:
PostgreSQL 11 adds support for foreign keys for partitioned tables. In Citus 8.0, we have two issues/limitations with foreign keys from partitioned tables.
The first one is related with Citus MX: citusdata/citus#2406 https://github.com/citusdata/citus/issues/2406 The other one is related with Online rebalancer when a partitioned table have a foreign key to a reference table: citusdata/citus-enterprise#284 https://github.com/citusdata/citus-enterprise/issues/284
Do we want to capture the limitations in the docs?
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/citusdata/citus_docs/issues/783#issuecomment-431271656, or mute the thread https://github.com/notifications/unsubscribe-auth/ACeeC4bZJ37tk_iiiYArSGBueUX2IC00ks5umX_pgaJpZM4W9XWL .
--
Sumedh Pathak Co-founder and VP Engineering | Citus Data | (650) 422 9797
