Divide Create Projection's process into several times.

KaitoKaito Employee, Registered User

I want to create a new super projection for a large fact table. To avoid having a bad impact for server resource, I want to resume the proccess to prepare for the projection nightly. Is it possible?

To prevent performance degradation, Is the only choice to use Refresh Resource Pool?

https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/Built-inPools.htm#REFRESH

Thanks in advance,

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file