resource pools

axnels2axnels2 Vertica Customer

if we have resource pools defined but not used or assigned to an existing user, does it use available memory?

Best Answers

Answers

  • axnels2axnels2 Vertica Customer

    thank you for clarifying that.

  • axnels2axnels2 Vertica Customer

    on a different topic, we have a constantly running etl processes on some tables that have data from the traffic across entire network. I have analyze scheduled to run every 15 minutes but was told that might be creating more issues. What is a rule of thump for constantly changing data tables.

  • axnels2, are you asking about how frequently should you be loading the table, or are you concerned about the impacts of querying against a table that you're always loading into? What is the nature of the issue here?

  • axnels2axnels2 Vertica Customer

    I am asking about how often should I be collecting statistics on a given table because its changing constantly.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file