high latency SELECT from a distributed table

[Mai Phong]

Hi,

We are looking for a solution to shard our current dataset with elixir ecto and citus looks promising. However, when we distributed our table, SELECT query tooks more than 100ms in additional to return result from a simple query. I tried to reduce task_tracker_delay but it doesn't help

Thanks

[Mai Phong]

SET citus.task_executor_type TO router;

set task_executor_type to router reduce the latency to around 2-5 ms. Thanks to Sai and Citus team that helping me out

[Marco Slot]

Note that as of Citus 5.1, the router executor setting will go away and the regular (real-time) executor will automatically switch to the router executor when possible.