Welcome to the Vertica Forum

Discussion List

• 
  Eon Mode - Performance if data is not in the Depot and policy to rehydrate

  Answered Min_Yun_Chan 521 views 3 comments 0 points Most recent by skamat April 2020General Discussion
• 
  What are some query performance troubleshooting tips?

  Answered rjs_docs 526 views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Scheduled analyzed_statistics on a table

  Answered kxu 484 views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Best practices and tips for tuning analytical functions?

  Answered rjs_docs 516 views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Eon Mode - How is backup, recovery, and migration handled?

  Answered Min_Yun_Chan 551 views 3 comments 0 points Most recent by Afe April 2020General Discussion
• 
  Best practices when combining multiple fact tables?

  Answered rjs_docs 482 views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Is the catalog part of the depot?

  Answered GaryG 492 views 2 comments 0 points Most recent by ChuckB April 2020General Discussion
• 
  Does an unused resource pool consume memory?

  Answered Deb_Chatigny 504 views 1 comment 0 points Most recent by skamat April 2020General Discussion
• 
  What are some guidelines for measuring query performance for my environment?

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

  Answered Deb_Chatigny 542 views 1 comment 0 points Most recent by Jan_Soubusta April 2020General Discussion
• 
  Memory usage and joins

  Answered kxu 481 views 1 comment 0 points Most recent by skamat April 2020General Discussion
• 
  Reading and writing controls - how does Eon mode on HDFS's approach compare to Eon mode on S3?

  Deb_Chatigny 503 views 1 comment 0 points Most recent by jheffner April 2020General Discussion
• 
  Moving data between S3 buckets

  Answered ✓ GaryG 545 views 1 comment 0 points Most recent by MarkH April 2020General Discussion
• 
  Migration from Enterprise to EON mode?

  Answered MichaelJK 755 views 2 comments 0 points Most recent by MarkH April 2020General Discussion
• 
  Vertica vs. open source technologies

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

  Answered GaryG 493 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  How does a projection's ORDER BY clause impact performance?

  Answered rjs_docs 564 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 521 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Optimizing a query with several joins

  Answered kxu 519 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Monitoring memory usage

  Answered kxu 798 views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion
• 
  Ways to minimize S3 fetches and without affecting performance?

  Answered kxu 484 views 1 comment 0 points Most recent by s_crossman April 2020General Discussion
• 
  What should my depot size be?

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

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

  Answered Deb_Chatigny 501 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Can secondary subcluster continue working when primary subcluster is down?

  Answered Min_Yun_Chan 482 views 2 comments 0 points Most recent by dsprogis April 2020General Discussion
• 
  JFMT hints on merge?

  Answered ✓ Deb_Chatigny 481 views 2 comments 0 points Most recent by Jan_Soubusta April 2020General Discussion
• 
  Eon Mode - Do Eon features for onsite clusters use different licensing plans?

  Answered Min_Yun_Chan 481 views 1 comment 0 points Most recent by dsprogis April 2020General Discussion
• 
  Tools for investigating query performance?

  Answered Deb_Chatigny 544 views 1 comment 0 points Most recent by siddyash April 2020General Discussion
• 
  Eon Mode on Azure availability?

  Answered ✓ GaryG 623 views 1 comment 0 points Most recent by cdaly1970 April 2020General Discussion
• 
  Duration for data update between clusters

  Answered Min_Yun_Chan 482 views 1 comment 0 points Most recent by Pan April 2020General Discussion