The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Divide Create Projection's process into several times.

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?

Thanks in advance,


  • I think your best bet would be to create a new table with your new projection(s) and incrementally load every night. Hopefully the table is partitioned so you can prevent some seek overhead.

  • KaitoKaito Employee

    Thank you!

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.