Welcome to the Vertica Forum

Resource Pools

Discussion List

• 
  SYSQUERY_POOL_SPILL event in dc_execution engine events: Any concerns?

  Accepted Answer Sudhakar_B 186 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 295 views 1 comment 0 points Most recent by Jim_Knicely August 2020General Discussion
• 
  Fast bulkload for flex tables

  Accepted Answer rajatpaliwal86 407 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 367 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 335 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 345 views 1 comment 0 points Most recent by JoeGonzalezVertDBA April 2020General Discussion
• 
  Planned concurrency and resource pools?

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

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

  Answered Deb_Chatigny 366 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 336 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 365 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 335 views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion
• 
  Should query_budget be at least 1GB?

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

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

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

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

  Answered rjs_docs 339 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 335 views 1 comment 0 points Most recent by ybei April 2020General Discussion