Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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?


  • SruthiASruthiA Employee



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




    Thank you,


  • Hi Sruthi,


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





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.