We have a 12 Vertica nodes cluster. Each node has 24 cores. I'm testing different settings for resource pool. Two settings are like following:
CREATE RESOURCE POOL parallel_24
EXECUTIONPARALLELISM 24;
CREATE RESOURCE POOL parallel_6
EXECUTIONPARALLELISM 6;
And then I run a test query using these two resource pools separately and then use the following query to verify the test query does use the correct resource pool.
SELECT * FROM query_profiles, resource_acquisitions
where resource_acquisitions.transaction_id = query_profiles.transaction_id and
resource_acquisitions.statement_id = query_profiles.statement_id and
query_profiles.transaction_id=94575592175788847 and
query_profiles.statement_id = 1
I list part of columns generated by the above query:
pool_name thread_count duration_ms
parallel_24 356 3500
pool_name thread_count duration_ms
parallel_6 362 9000
From the above result, we can clearly see that increasing the parallelism reduce the running time. But I did not understand the thread_count from two aspects: (1) why there are so many threads involved? (2) parallel_6 even has more threads than parallel_24? (3) what does thread_count really mean?
Thanks,
usage of resource pools
Moderator: NorbertKrupa
Return to “Vertica Database Administration”
Jump to
- General
- ↳ Welcome to vertica-forums.com!
- ↳ Board Announcements
- ↳ Request for New Forums Categories
- ↳ Announcements, Events and Activities
- ↳ Vertica Links
- ↳ General
- ↳ Employment
- ↳ Vertica Certification
- Newbie
- ↳ New to Vertica
- ↳ New to Vertica Database Administration
- ↳ New to Vertica Database Development
- ↳ New to Vertica SQL
- Using Vertica
- ↳ Vertica Database Administration
- ↳ Vertica Database Development
- ↳ Vertica SQL
- ↳ Vertica SQL Functions
- ↳ Vertica Database Designer (DBD)
- ↳ Vertica User Defined Functions (UDFs)
- ↳ Vertica External Procedures
- ↳ Vertica Analytics
- ↳ Vertica Management Console
- ↳ Vertica Error Codes
- ↳ Vertica Backup & Recovery
- ↳ Vertica Installation
- ↳ Vertica Security
- ↳ Vertica Performance Tuning
- ↳ Vertica Administration Tools
- ↳ Vertica Upgrade
- ↳ Vertica Migration
- ↳ Vertica and the Operating System
- ↳ Vertica Data Load
- ↳ Vertica Tips, Lessons and Examples
- ↳ Vertica "How to..."
- Connecting to Vertica
- ↳ ADO.NET
- ↳ Cognos
- ↳ DBeaver
- ↳ dbVisualizer
- ↳ HDFS Connector
- ↳ Hadoop Connector
- ↳ HCatalog Connector
- ↳ Informatica PowerCenter
- ↳ JDBC
- ↳ Microsoft SQL Server Analysis Services (SSAS)
- ↳ MicroStrategy
- ↳ Microsoft SQL Server Integration Services (SSIS)
- ↳ ODBC
- ↳ Perl
- ↳ PHP
- ↳ Python
- ↳ R Language Integration
- ↳ Rhapsody Interface Engine
- ↳ SQL Workbench/J
- ↳ SQuirreL SQL Client
- ↳ Talend
- ↳ Tableau
- ↳ Toad for Data Analysts
- ↳ Vertica SDK API
- ↳ VoltDB
- ↳ vSQL
- Vertica Portfolio
- ↳ Vertica Premium Edition
- ↳ Vertica Express Edition
- ↳ Vertica Community Edition
- ↳ Vertica SQL on Hadoop
- ↳ Vertica in the AWS Cloud
- ↳ Vertica on Microsoft Azure
- All times are UTC+01:00
- Top
- Delete all board cookies
Powered by phpBB ® | phpBB3 theme by KomiDesign