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)