performance

Discussion List

• 
  slower querying speed after 1Billion records

  Answered prad33p2301 4.6K views 5 comments 0 points Most recent by Sergey_Cherepan_1 March 22General Discussion
• 
  How is it possible to assign resources exclusively to a custom pool?

  Answered ✓ jorodriguezr 22.3K views 12 comments 0 points Most recent by jorodriguezr June 2023General Discussion
• 
  Reading Query Plan And Optimizing It

  Answered suryateja 6.5K views 3 comments 0 points Most recent by mosheg May 2023General Discussion
• 
  How does Vertica handle large-scale data processing?

  Answered brettlee 2.9K views 1 comment 0 points Most recent by VValdar April 2023General Discussion
• 
  SALT in Segmentation Clause

  Answered ✓ mferrall 11.1K views 4 comments 0 points Most recent by VValdar August 2022General Discussion
• 
  Optimizing Vertica Schemas for a Low Latency Application

  mferrall 11.1K views 4 comments 0 points Most recent by mferrall July 2022General Discussion
• 
  Vertica 11 Why didn't optimizer chose new DBD projection?

  Answered Pacocha 10.9K views 4 comments 0 points Most recent by Pacocha May 2022General Discussion
• 
  Vertica ADO.NET: Degraded performance with connection pooling enabled

  Answered viveks 18.5K views 7 comments 0 points Most recent by Hibiki January 2022General Discussion
• 
  eon performance

  Answered vcarusi 10.9K views 4 comments 0 points Most recent by vcarusi November 2021General Discussion
• 
  Definition for v_monitor.cpu_usage

  Answered ✓ Tim_1 6.2K views 2 comments 0 points Most recent by Tim_1 November 2021General Discussion
• 
  Table performance improvement

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

  Answered ✓ Sudhakar_B 16.3K views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
• 
  Hybrid Flex table performance vs standard table

  Answered rajatpaliwal86 11.8K 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 4K views 1 comment 0 points Most recent by deepikaym December 2020General Discussion
• 
  vertica performance monitoring

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

  Answered rajatpaliwal86 16.4K 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 6.6K views 2 comments 1 point Most recent by sma July 2020General Discussion
• 
  Using Vertica to store files

  Answered ✓ rajatpaliwal86 14.4K views 5 comments 0 points Most recent by rajatpaliwal86 June 2020General Discussion
• 
  Vertica new cluster running slow

  Answered ✓ davds 58.1K views 23 comments 0 points Most recent by mosheg May 2020General Discussion
• 
  vertica constraint enforcement and deduplication

  Answered ✓ rajatpaliwal86 16.7K views 6 comments 0 points Most recent by rajatpaliwal86 May 2020General Discussion
• 
  Fast bulkload for flex tables

  Answered ✓ rajatpaliwal86 26.4K views 10 comments 1 point Most recent by rajatpaliwal86 May 2020Product Feedback
• 
  numeric vs float data type performance

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

  Answered ✓ yossibm 19.8K views 6 comments 0 points Most recent by yossibm April 2020General Discussion
• 
  About the performance of the query

  Answered ✓ yamakawa 6.5K views 2 comments 0 points Most recent by yamakawa April 2020General Discussion
• 
  When to resegment/broadcast?

  Answered kxu 9.1K views 3 comments 0 points Most recent by cp00634326 April 2020General Discussion
• 
  Where can I find documentation for query performance and resource pools?

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

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

  Answered Min_Yun_Chan 4.1K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion