My question is kind of related to another topic:
viewtopic.php?f=4&t=1782
My database has ALOT of projection columns with the encoding type AUTO. Is this something I need to be concerned about?
See:
Code: Select all
dbadmin=> select encoding_type, count(*) from projection_columns group by encoding_type order by 2 desc;
encoding_type | count
------------------+-------
AUTO | 25475
RLE | 1066
COMMONDELTA_COMP | 308
DELTAVAL | 39
BLOCKDICT_COMP | 38
DELTARANGE_COMP | 36
(6 rows)