OpenText Vertica Workshop: Architecture & Performance Deep Dive

This workshop video - presented by three avatars including myself - offers a practical and performance-focused guide to OpenText Vertica, tailored for users with SQL experience. We start with Vertica's architecture and key capabilities, then dive deep into performance optimization techniques that unlock the full power of this MPP database.

📌 Recorded: July 11, 2025
🎙 Presenter: Moshe Goldberg, Principal Solutions Consultant, OpenText Vertica

What You’ll Learn:

Getting Started:
✅ What Vertica is and how it works
✅ Key features: projections, separation of compute/storage, deployment modes (Enterprise vs Eon)
✅ Machine learning in-database with full SQL workflow
✅ External table querying and complex data types

Performance Deep Dive:
✅ Smart projection design and segmentation
✅ Vertica Database Designer (DBD) best practices
✅ Efficient encoding, memory usage, and query profiling (with qprof)
✅ Join strategies (Merge vs Hash), GROUP BY tuning, and COUNT(DISTINCT) optimization
✅ Data load fault tolerance and error handling
✅ Statistics management, tuning tips, and optimizer hints

Key Slide Topics Include:
1. Vertica Projections
2. Projection Replication & Segmentation
3. Database Designer & Auto-Projection Generation
4. Best Practices for Table Design
5. Encoding Optimization
6. Query Profiling with qprof
7. Join Algorithms: Merge vs. Hash
8. GROUP BY Execution Types (Hash vs. Pipelined)
9. COUNT(DISTINCT) Performance Strategies
10. Smart SQL Practices & Error Tolerance
11. Data Loading Tips
12. Statistics Collection Triggers & Tuning
13. Quick Wins for Query Speedup

🔍 Designed for engineers and Vertica analysts who want to build fast, scalable data solutions using Vertica.

#Vertica #OpenText #Analytics #SQL #DataEngineering #PerformanceTuning #DatabaseOptimization

Видео OpenText Vertica Workshop: Architecture & Performance Deep Dive канала Moshe