citus icon indicating copy to clipboard operation
citus copied to clipboard

citus_columnar as a separate extension and shared_preload_libraries

Open Green-Chan opened this issue 1 year ago • 1 comments

Hi! citus_columnar is enabled as a separate extension since v11.1, but it is still not documented (#7189). Release notes say

make sure that citus_columnar is in the shared_preload_libraries if you want to use only columnar features of Citus

Is it really needed for the correct work of citus_columnar? If so, then why when trying to CREATE EXTENSION citus_columnar without citus_columnar in the shared_preload_libraries there is no error? When doing the same for citus user gets

ERROR:  Citus can only be loaded via shared_preload_libraries
HINT:  Add citus to shared_preload_libraries configuration variable in postgresql.conf in master and workers. Note that citus should be at the beginning of shared_preload_libraries.

The same error for citus_columnar would be really helpful to prevent any problems that could occur when using citus_columnar as a separate extension without listing it in the shared_preload_libraries. It's especially important since no documentation is available and users can easily miss the necessity to specify shared_preload_libraries.

Green-Chan avatar Jan 15 '24 13:01 Green-Chan

+1

GPF199541 avatar Jan 17 '24 06:01 GPF199541