_FT_LogoSheet.1Sheet.2Sheet.3Analytics Database
  • 25.3.x
    25.3.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
    • OpenText Core Analytics Database
    • Supported platforms
    • New features
    • Getting started
    • Architecture
    • Setup
    • Eon
    • Container deployment
    • 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
      • 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 the DB
      • 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 OpenText Analytics Database
    • Extending OpenText Analytics Database
    • Hadoop integration
    • Kafka integration
    • Spark integration
    • Voltage SecureData integration
    • SQL reference
    • API reference
    • Database 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