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

Retentive Refresh

I just saw a make_ahm_now() statement fail with the error "AHM can't be set while retentive refresh is running."

 

What exactly is a retentive refresh?

Comments

  • SruthiASruthiA Employee

    Hi,

     

          Retentive refresh is used if projection has up to date buddy projections. When retentive refresh is running, you cannot advance AHM.

     

     

     

    Thank you,

     Sruthi

  • Hi Sruthi,

     

    Thanks for the reply!  How often do these refreshes run?

     

    Thanks,

     

    --Steven

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.