Disk space during projection refresh
Currently unable to refresh a projection as it keeps running out of disk space. How much space is needed to refresh a projection? On each node (3 node) the projection as compressed on disk is about 100GB, and each node has about 1TB free, yet refreshing that projection keeps using disk space until the 1TB per node is consumed and it fails.
Is 10x expansion of data during a refresh normal? How can we ever do a refresh without massively overprovisioning disk if so?
I also notice that Vertica is trying to refresh both buddy projections at the same time. Can we manually refresh one then the other? Maybe that will squeeze through.