citus can I use join if I use citus?

Question

citus can I use join if I use citus ?

And yes are they performant ?

.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

Answer 1

citus can I use join if I use citus ?

Yes, you can use joins with Citus.
https://docs.citusdata.com/en/v10.0/develop/reference_sql.html#joins.

Most of the joins between different Citus table types are just supported, but some of them requires enabling repartition joins.
https://docs.citusdata.com/en/v10.0/develop/api_guc.html?highlight=enable_repartition_joins#citus-enable-repartition-joins-boolean

As of Citus 10, joins between local tables and distributed tables are also supported.
https://docs.citusdata.com/en/v10.0/develop/api_guc.html?highlight=enable_repartition_joins#citus-local-table-join-policy-enum

And yes are they performant ?

Citus joins tables very efficiently when tables are co-located.
https://docs.citusdata.com/en/v10.0/develop/reference_sql.html#co-located-joins