Do projections require manual refresh? Are they not automatically updated during DML transactions?
Projections do not require manual refresh following DML operations. A projection refresh is only necessary after creating a new one.
Thanks. So, does this mean there's no need to check for stale projections?
No. It's very important to make sure all projections are "up to date".
This query should always return 0:
dbadmin=> SELECT COUNT(*) FROM projections WHERE NOT is_up_to_date;
Otherwise your AHM will fall behind and not advance.
what causes projections to become stale? sorry for asking this, but I am trying to find information from the documentation, but I couldn't find any.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.