zhangjiazhi

deleting data:
select master_modify_multiple_shards(‘delete from github_events where created_at >=  ''2015-01-01 00:00:00’’’)

join:
citus.large_table_shard_count default value 4 treat as large table  , evaluates several possible join order require minimum data to be transferred across network

broadcast join:
replicate the small table

co-located joins: