> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8c05c8a2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Managing ClickStack

> Managing ClickStack

This section describes how to manage ClickStack.

<h2 id="admin-guides">
  Admin guides
</h2>

| Section                                                           | Description                                                                                                 |
| ----------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- |
| [Basic administration](/clickstack/managing/admin)                | An introduction to performing common administrative tasks in ClickStack.                                    |
| [Estimating resources](/clickstack/managing/estimating-resources) | Guidance on sizing compute resources for Managed ClickStack based on ingest volume.                         |
| [Going to production](/clickstack/managing/production)            | Recommended steps and best practices before running ClickStack in production.                               |
| [Materialized views](/clickstack/managing/materialized-views)     | A detailed guide to using materialized views in ClickStack to accelerate query performance.                 |
| [Performance tuning](/clickstack/managing/performance-tuning)     | A comprehensive guide to tuning ClickStack for large-scale workloads.                                       |
| [RBAC](/clickstack/managing/rbac)                                 | Configure role-based access control to manage team permissions for dashboards, saved searches, and sources. |

<h2 id="core-concepts">
  Core ClickHouse concepts
</h2>

Most ClickStack management tasks require familiarity with the underlying ClickHouse database. We recommend reviewing the following core ClickHouse concepts outlined below before performing administrative or performance-related operations.

| Concept                     | Description                                                                                                                                                                           |
| --------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Tables**                  | How ClickStack data sources map to underlying ClickHouse tables. ClickHouse tables primarily use the [MergeTree](/reference/engines/table-engines/mergetree-family/mergetree) engine. |
| **Parts**                   | How data is written as immutable parts and merged over time.                                                                                                                          |
| **Partitions**              | Logical groupings of table parts that simplify data management, querying, and optimization.                                                                                           |
| **Merges**                  | The background process that combines parts to reduce the number of parts queried and maintain performance.                                                                            |
| **Granules**                | The smallest unit of data read and pruned during query execution.                                                                                                                     |
| **Primary (ordering) keys** | How the `ORDER BY` key defines on-disk data layout, compression, and query pruning behavior.                                                                                          |

These concepts are fundamental to ClickHouse performance and will help you make informed administrative decisions when managing ClickStack.