_FT_LogoSheet.1Sheet.2Sheet.3Analytics Database
  • 25.1.x
    25.2.x 25.1.x 24.4.x 24.3.x 24.2.x 24.1.x 23.4.x 23.3.x 12.0.x 11.1.x 11.0.x 10.1.x 10.0.x 9.3.x 9.2.x 9.1.x 9.0.x 8.1.x
  • English
    中文
English
中文
  • Documentation
    • Supported platforms
    • New features
    • OpenText Core Analytics Database
    • Getting started
    • Architecture
    • Setup
    • Eon
    • Containerized Vertica
    • Data exploration
    • Data load
    • Data analysis
    • Flex tables
    • Data export and replication
    • Management Console
    • Administrator's guide
      • Administration overview
      • Managing licenses
      • Configuring the DB
      • DB users & privileges
      • Using admin tools
      • Operating the DB
      • Working with native tables
      • Managing client connections
      • Projections
      • Partitioning tables
      • Constraints
      • Managing queries
      • Transactions
      • Vertica DB locks
      • Using text search
      • Managing storage locations
      • Analyzing workloads
      • Managing the DB
        • Managing nodes
        • Managing disk space
        • Memory usage reporting
        • Memory trimming
        • Tuple mover
        • Managing workloads
          • Resource manager
          • Resource pool architecture
          • Managing resources at query run time
          • Restoring resource manager defaults
          • Best practices for managing workload resources
            • Basic principles for scalability & concurrency tuning
            • Setting a runtime limit for queries
            • Handling session socket blocking
            • Managing workloads with resource pools & user profiles
            • Tuning built-in pools
              • Restricting Vertica to take only 60% of memory
              • Tuning for recovery
              • Tuning for refresh
              • Tuning tuple mover pool settings
              • Tuning for machine learning
            • Reducing query run time
            • Managing workload resources in an Eon DB
          • Managing system resource usage
        • Node Management Agent
        • HTTPS service
      • Monitoring Vertica
      • Backing up & restoring the DB
      • Failure recovery
      • Collecting DB statistics
      • Using diagnostic tools
      • Profiling DB performance
      • About locale
      • Creating native binary format files
      • Database management with VCluster
    • Security & authentication
    • Connecting to Vertica
    • Extending Vertica
    • Hadoop integration
    • Kafka integration
    • Spark integration
    • Voltage SecureData integration
    • SQL reference
    • API reference
    • Vertica error messages
    • Glossary
    • Copyright notice

Thanks for your feedback!

Send feedback








Submitting...

Print entire section
  1. Administrator's guide
  2. Managing the DB
  3. Managing workloads
  4. Best practices for managing workload resources
  5. Tuning built-in pools

Tuning built-in pools

The scenarios in this section describe how to tune built-in pools.

The scenarios in this section describe how to tune built-in pools.

  • Restricting Vertica to take only 60% of memory
  • Tuning for recovery
  • Tuning for refresh
  • Tuning tuple mover pool settings
  • Tuning for machine learning

In this section

  • Restricting Vertica to take only 60% of memory
  • Tuning for recovery
  • Tuning for refresh
  • Tuning tuple mover pool settings
  • Tuning for machine learning
© 2025 Open Text Corporation All Rights Reserved
Privacy Policy
Cookie Preferences