Monitoring Projection Refresh on Buddy Projections
Vertica refreshes projections only after you create a buddy projection. If you run START_REFRESH
after creating a projection, Vertica returns this message:
Starting refresh background process
However, the refresh begins only after you create buddy projections.
To confirm whether a refresh operation is complete, review the vertica.log
file. GET_PROJECTIONS
also provides the final status of the projection refresh:
=> SELECT GET_PROJECTIONS('customer_dimension'); GET_PROJECTIONS ----------------------------------------------------------------
Current system K is 1. # of Nodes: 3. Table public.customer_dimension has 2 projections. Projection Name: [Segmented] [Seg Cols] [# of Buddies] [Buddy Projections] [Safe] [UptoDate] [Stats] ---------------------------------------------------------------------------------------------------- public.customer_dimension_unseg [Segmented: No] [Seg Cols: ] [K: 2] [public.customer_dimension_unseg] [Safe: Yes] [UptoDate: Yes] [Stats: Yes] public.customer_dimension_DBD_1_rep_VMartDesign_node0001 [Segmented: No] [Seg Cols: ] [K: 2] [public.customer_dimension_DBD_1_rep_VMartDesign_node0001] [Safe: Yes] [UptoDate: Yes] [Stats: Yes] (1 row)