Welcome to the Vertica Forum

Discussion List

• 
  Table performance improvement

  hqVert 191 views 0 comments 0 points Started by hqVert February 19 General Discussion
• 
  SYSQUERY_POOL_SPILL event in dc_execution engine events: Any concerns?

  Accepted Answer Sudhakar_B 383 views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
• 
  Hybrid Flex table performance vs standard table

  Answered rajatpaliwal86 650 views 4 comments 0 points Most recent by Pieter_Sheth-Vo December 2020General Discussion
• 
  vertica corresponding Management Console - Activity with data collector tables

  Answered maks 366 views 1 comment 0 points Most recent by deepikaym December 2020General Discussion
• 
  vertica performance monitoring

  Answered maks 352 views 2 comments 0 points Most recent by maks November 2020General Discussion
• 
  Tuning multiple copy commands in parallel

  Answered rajatpaliwal86 506 views 6 comments 0 points Most recent by rajatpaliwal86 September 2020General Discussion
• 
  query plan is different between select from table and select from view

  sma 521 views 2 comments 1 point Most recent by sma July 2020General Discussion
• 
  Using Vertica to store files

  Accepted Answer rajatpaliwal86 617 views 5 comments 0 points Most recent by rajatpaliwal86 June 2020General Discussion
• 
  Vertica new cluster running slow

  Accepted Answer davds 785 views 23 comments 0 points Most recent by mosheg May 2020General Discussion
• 
  Advice for tuning execution parallelism?

  Answered Deb_Chatigny 869 views 5 comments 1 point Most recent by JoeGonzalezVertDBA May 2020General Discussion
• 
  vertica constraint enforcement and deduplication

  Accepted Answer rajatpaliwal86 632 views 6 comments 0 points Most recent by rajatpaliwal86 May 2020General Discussion
• 
  Fast bulkload for flex tables

  Accepted Answer rajatpaliwal86 626 views 10 comments 1 point Most recent by rajatpaliwal86 May 2020Product Feedback
• 
  numeric vs float data type performance

  Answered yossibm 502 views 1 comment 0 points Most recent by yossibm April 2020General Discussion
• 
  How to add a new column to a table efficiently?

  Accepted Answer yossibm 1K views 6 comments 0 points Most recent by yossibm April 2020General Discussion
• 
  About the performance of the query

  Accepted Answer yamakawa 501 views 2 comments 0 points Most recent by yamakawa April 2020General Discussion
• 
  How efficient is storage of complex types?

  Answered Deb_Chatigny 511 views 5 comments 0 points Most recent by alfred0809 April 2020General Discussion
• 
  When to resegment/broadcast?

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

  Answered Deb_Chatigny 481 views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Does ordering by lots of columns hurt performance?

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

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

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

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

  Answered rjs_docs 501 views 1 comment 0 points Most recent by twall April 2020General Discussion
• 
  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 522 views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Scheduled analyzed_statistics on a table

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

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

  Answered rjs_docs 492 views 1 comment 0 points Most recent by skamat April 2020General Discussion