Skip to main content

Knowledge Document: Projection Size issue

  • March 19, 2026
  • 0 replies
  • 3 views

coest_opentext_com
Forum|alt.badge.img

Environment

Analytics Database 25.2
 

Situation

An issue has been identified involving super projections in the database. Recent troubleshooting actions appear to have affected not only existing projections but also the engine’s behavior when generating new super projections for newly created tables. A comparative test was executed on both the new cluster and the previous Vertica environment by loading an 85 GB CSV file into an empty table created specifically for validation. In the older database, the loaded table occupies approximately 15 GB. In the new cluster, the same dataset results in a table size of nearly 35 GB—more than double the previous footprint.
Clarification is needed regarding the underlying cause of this discrepancy and the changes occurring within the database engine.

 

Find resolution on support portal