GitHub user gfphoenix78 added a comment to the discussion: PAX Storage: Questions for PAX developers
The bloom filter and minmax info are stored both in the auxiliary table per micro-partition file, and in the micro-partition file per group. The total size of bloom filter storage is: `n_columns * n_files * (1 + n_agpf) * aspt` ``` n_columns: the number of columns that use bloom filter in a table. n_files: the number of micro partition files of the pax table. n_agpf: the average number of groups per file aspt: the average size of bloom filter storage per type. ``` The default estimated size of bloom filter storage for a column is 8KB, i.e. aspt. GitHub link: https://github.com/apache/cloudberry/discussions/1421#discussioncomment-14826581 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
