Welcome to the Vertica Forum

Resource Pools

Discussion List

• 
  SYSQUERY_POOL_SPILL event in dc_execution engine events: Any concerns?

  Accepted Answer Sudhakar_B 313 views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
• 
  Is there a way to set queuetimeout at query or session level?

  Accepted Answer brocha 430 views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Fast bulkload for flex tables

  Accepted Answer rajatpaliwal86 541 views 10 comments 1 point Most recent by rajatpaliwal86 May 2020Product Feedback
• 
  Where can I find documentation for query performance and resource pools?

  Answered rjs_docs 487 views 2 comments 0 points Most recent by rjs_docs April 2020General Discussion
• 
  Real memory usage doesn't match resource groups; how can we improve estimation of query needs?

  Answered Deb_Chatigny 457 views 1 comment 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  Can a resource pool reject queries that are too large, instead of accepting them and running them mo

  Answered Deb_Chatigny 468 views 1 comment 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  Planned concurrency and resource pools?

  Answered Deb_Chatigny 499 views 2 comments 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  Does an unused resource pool consume memory?

  Answered Deb_Chatigny 467 views 1 comment 0 points Most recent by skamat April 2020General Discussion
• 
  Does cascading do anything without replanning?

  Answered Deb_Chatigny 488 views 1 comment 0 points Most recent by Jan_Soubusta April 2020General Discussion
• 
  Is it possible to filter user queries based on cost?

  Answered GaryG 458 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Can I run an EXPLAIN query plan that rejects the query plan based on the returned Cost?

  Answered rjs_docs 488 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Do you still need resource pools if there's only one database user?

  Answered Deb_Chatigny 457 views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion
• 
  Should query_budget be at least 1GB?

  Answered Deb_Chatigny 468 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Does an unused resource pool reserve memory?

  Answered rjs_docs 459 views 1 comment 0 points Most recent by Pan April 2020General Discussion
• 
  Should I keep Vertica and HDFS on separate nodes?

  Answered rjs_docs 448 views 1 comment 0 points Most recent by mcellio April 2020General Discussion
• 
  How much memory does Vertica use with no configuration?

  Answered rjs_docs 461 views 1 comment 0 points Most recent by Jim_Knicely April 2020General Discussion
• 
  Updating table statistics?

  Answered rjs_docs 476 views 1 comment 0 points Most recent by Jim_Knicely April 2020General Discussion
• 
  Any plan to isolate resource pools on each subcluster?

  Answered Min_Yun_Chan 461 views 1 comment 0 points Most recent by ybei April 2020General Discussion