Cockroachdb status of cascade and foreign key relationships

hello -

according to an earlier forum question and this question, i see the following replies:

We don’t currently support CASCADE behaviors for update or delete

We plan to optimize this but in the meantime you may get better performance by issuing the 3 queries (to the node and parent tables) separately.

i just installed 1.1.5 - have either of these issues (cascade-delete & parent-child joins) been addressed? the earlier replies seemed to indicate they may eventually be.

side-note: am i the only one who noticed how ridiculously easy it is to get started with cockroachdb? i think when i tried to install posgresql they needed my blood type, if memory serves.

Cascading updates will be supported in CockroachDB 2.0 but will not yet be optimized for performance. Does this answer your concern?

1 Like

There will be some additional join optimizations in CockroachDB 2.0 as well. Not as much as needed to make your previous queries fast, I fear. For this you may need to wait until 2.1.

Does this answer your concern?

indeed it does. i am eagerly looking forward to v2.0 & 2.1.