Welcome to the Vertica Forum

performance

Discussion List

• 
  How efficient is storage of complex types?

  Answered mcellio 13 views 1 comment 0 points Most recent by ChuckB April 5General Discussion
• 
  Advice for tuning execution parallelism?

  Answered mcellio 24 views 3 comments 0 points Most recent by JoeGonzalezVertDBA April 5General Discussion
• 
  When to resegment/broadcast?

  Answered kxu 28 views 3 comments 0 points Most recent by cp00634326 April 3General Discussion
• 
  What are the performance implications for complex types over billions of rows?

  Answered mcellio 7 views 1 comment 0 points Most recent by ChuckB April 3General Discussion
• 
  Does ordering by lots of columns hurt performance?

  Answered mcellio 28 views 3 comments 0 points Most recent by ChuckB April 2General Discussion
• 
  Where can I find documentation for query performance and resource pools?

  Answered rjs_docs 37 views 2 comments 0 points Most recent by rjs_docs April 2General Discussion
• 
  Hints with pre-ANSI joins

  Answered kxu 10 views 1 comment 0 points Most recent by ChuckB April 2General Discussion
• 
  How do aggregate projections affect the load performance?

  Answered Min_Yun_Chan 12 views 1 comment 0 points Most recent by marcothesane April 2General Discussion
• 
  SELECT statement performance improvements?

  Answered rjs_docs 18 views 1 comment 0 points Most recent by twall April 2General Discussion
• 
  Eon Mode - Performance if data is not in the Depot and policy to rehydrate

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

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

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

  Answered rjs_docs 13 views 1 comment 0 points Most recent by baron42bba April 1General Discussion
• 
  What are some guidelines for measuring query performance for my environment?

  Answered rjs_docs 16 views 1 comment 0 points Most recent by skamat April 1General Discussion
• 
  Memory usage and joins

  Answered kxu 10 views 1 comment 0 points Most recent by skamat April 1General Discussion
• 
  How does a projection's ORDER BY clause impact performance?

  Answered rjs_docs 14 views 1 comment 0 points Most recent by ChuckB April 1General Discussion
• 
  Optimizing a query with several joins

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

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

  Answered kxu 11 views 1 comment 0 points Most recent by s_crossman April 1General Discussion
• 
  Tools for investigating query performance?

  Answered mcellio 13 views 1 comment 0 points Most recent by siddyash April 1General Discussion
• 
  Keeping up-to-date statistics on tables at scale

  Question kxu 9 views 0 comments 0 points Started by kxu April 1 General Discussion
• 
  Right-hand inserts and optimizer reports

  Question kxu 7 views 0 comments 0 points Started by kxu April 1 General Discussion
• 
  Viewing cluster activity during a global catalog lock

  Question kxu 3 views 0 comments 0 points Started by kxu April 1 General Discussion
• 
  Analyzing a constantly-loaded table

  Question kxu 7 views 0 comments 0 points Started by kxu April 1 General Discussion
• 
  ML - Feasibility and performance of analyzing all data on a Vertica cluster?

  Answered emichaud 25 views 1 comment 0 points Most recent by Vertica_Curtis April 1General Discussion
• 
  Hybrid Flex table performance vs standard table

  Answered rajatpaliwal86 58 views 1 comment 0 points Most recent by Ariel_Cary March 31General Discussion
• 
  incorrect vertica projection selection

  Answered rajatpaliwal86 39 views 1 comment 0 points Most recent by ChuckB March 31General Discussion
• 
  How to create text index on a flex table which has composite primary key

  Answered rajatpaliwal86 23 views 4 comments 0 points Most recent by rajatpaliwal86 February 7General Discussion
• 
  order by on JOIN of tables is very slow

  Answered rajatpaliwal86 70 views 4 comments 0 points Most recent by rajatpaliwal86 January 6Product Feedback
• 
  Joins on multiple(more than two) tables - extremely slow

  Answered rajatpaliwal86 79 views 9 comments 0 points Most recent by rajatpaliwal86 December 2019Product Feedback