v.21.4Improvements

Support Replicas Priority for Postgres Dictionary Source

Support replicas priority for postgres dictionary source. #21710 (Kseniia Sumarokova).
Support replicas priority for Postgres dictionary source.

Why it matters

This feature allows users to specify priority levels for replicas when using a Postgres dictionary source in ClickHouse. It helps in managing failover and load balancing by defining which PostgreSQL replicas should be preferred for dictionary queries, improving reliability and performance.

How to use it

Users can configure the priority of PostgreSQL replicas in the dictionary source settings by specifying replica connection details along with their priorities, enabling ClickHouse to select the appropriate replica based on the configured priorities.