Skip to main content
Question

Resident Size and Virtual Size in dc_process system table

  • April 20, 2020
  • 2 replies
  • 11 views
cp00634326
Forum|alt.badge.img+1

Hi ,Could you please explain the Resident Size and Virtual size columns in dc_process_info table .The column value in the table,is it related to system memory or vertica memory.I can see ver time both the memory getting higher .Would be really helpful if any doc related to this table

    2 replies

    sahil_kumar
    Forum|alt.badge.img
    • sahil_kumar
    • Participating Frequently
    • May 11, 2020

    dc_process_info contains information about vertica process memory, handles and system limits.
    If the resident_size_min_value is growing gradually over time , please check below forum post as it may be helpful.
    https://forum.vertica.com/discussion/comment/243701#Comment_243701

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • May 11, 2020

    You can get short description of data collector tables and other information like retention policy from system table data_collector

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement