Vertica Forum

Discussion List

• 
  projection_storage total usage vs disk_storage/storage_usage

  Answered logc 8.1K views 2 comments 0 points Most recent by logc April 2020General Discussion
• 
  Eon Mode - Performance if data is not in the Depot and policy to rehydrate

  Answered Min_Yun_Chan 11K views 3 comments 0 points Most recent by [Deleted User] April 2020General Discussion
• 
  What are some query performance troubleshooting tips?

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

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

  Answered rjs_docs 5K views 1 comment 0 points Most recent by baron42bba April 2020General Discussion
• 
  Whats causes an "Outer (RESEGMENT)(LOCAL ROUND ROBIN)" during a JOIN?

  Answered rikusg 5.4K views 1 comment 0 points Most recent by pnthao April 2020General Discussion
• 
  Slack or PagerDuty to monitor Vertica

  Answered Bryan_H 5K 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 11K views 3 comments 0 points Most recent by Afe April 2020General Discussion
• 
  Best practices when combining multiple fact tables?

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

  Answered GaryG 7.9K views 2 comments 0 points Most recent by ChuckB April 2020General Discussion
• 
  Eon Mode pricing

  Answered J_Kelley 8.4K views 2 comments 0 points Most recent by ianadankova April 2020General Discussion
• 
  Choosing between Vertica on AWS or HDFS?

  Answered J_Kelley 4.9K views 1 comment 0 points Most recent by dsprogis April 2020General Discussion
• 
  What are some guidelines for measuring query performance for my environment?

  Answered rjs_docs 4.9K views 1 comment 0 points Most recent by [Deleted User] April 2020General Discussion
• 
  Memory usage and joins

  Answered kxu 4.9K views 1 comment 0 points Most recent by [Deleted User] April 2020General Discussion
• 
  Query performance for non-depot data

  Answered J_Kelley 4.9K views 1 comment 0 points Most recent by dsprogis April 2020General Discussion
• 
  How to force optimizer to broadcast table and use as inner source in hash join

  Answered Sergey_Cherepan_1 8.3K views 2 comments 0 points Most recent by pnthao April 2020General Discussion
• 
  Moving data between S3 buckets

  Answered ✓ GaryG 5.1K views 1 comment 0 points Most recent by MarkH April 2020General Discussion
• 
  Eon Mode on Azure features

  Answered J_Kelley 4.9K views 1 comment 0 points Most recent by dsprogis April 2020General Discussion
• 
  Data reorganization for Eon Mode migration

  J_Kelley 19.4K views 1 comment 0 points Most recent by MarkH April 2020General Discussion
• 
  Migration tools for transition from Enterprise to Eon Mode

  Answered J_Kelley 4.9K views 1 comment 0 points Most recent by MarkH April 2020General Discussion
• 
  How does Eon implement K-safety and segmented projections?

  Answered MichaelJK 5.3K views 1 comment 0 points Most recent by MarkH April 2020General Discussion
• 
  Requests to subclusters vs primary

  Answered J_Kelley 4.9K views 1 comment 0 points Most recent by Pan April 2020General Discussion
• 
  Migration from Enterprise to EON mode?

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

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

  Answered GaryG 4.9K 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 5.2K 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 5K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Optimizing a query with several joins

  Answered kxu 5K views 1 comment 0 points Most recent by ChuckB April 2020General Discussion
• 
  Scripting LDAP authentication for the management console

  Question Bill_Chartrand 1.9K views 0 comments 0 points Most recent by Bill_Chartrand April 2020General Discussion
• 
  Monitoring memory usage

  Answered kxu 5.4K views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion