Indexing performance optimization
A curated collection of agent skills for your AI agents - engineering craft, prompt engineering, design, growth marketing, ...
npx -y skills add mouadja02/skills --skill indexing-performance-optimizationAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 8 stars8 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Use when diagnosing slow Qdrant ingestion, delayed optimizer completion, long HNSW builds, or payload-index construction.
The file declares its own license as Apache-2.0. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.
SKILL.md
7.0 KB, ~1.5k tokens by cl100k_base, as published. Nobody here has run it
Attribution: Sourced from qdrant/skills by Qdrant.
When to Use
- Upload/upsert throughput is below target.
- Optimizer work or HNSW construction does not finish in the expected window.
- Payload-index creation dominates an ingestion or migration window.
Do not use this skill when ingestion is healthy and only query latency or memory footprint is problematic. Use the sibling search or memory skill instead.
Prerequisites and Quick Reference
- Record Qdrant version, point/vector sizes, batch size, client concurrency, shard count, collection configuration, optimizer status, and CPU/disk/network utilization.
- Keep a tested rollback configuration and a representative non-production collection.
- Classify first: client/network, server ingestion, optimizer backlog, HNSW build, or payload-index build.
- Measure points/second, request errors, optimizer completion time, resource saturation, and post-build search quality.
The Qdrant links below are sourced facts and upstream guidance. The isolation order, rollback discipline, and acceptance checks are repository recommendations.
What to Do When Qdrant Indexing Is Too Slow
Qdrant does NOT build HNSW indexes immediately. Small segments use brute-force until they exceed indexing_threshold_kb (default: 20 MB). Search during this window is slower by design, not a bug.
- Understand the indexing optimizer Indexing optimizer
Uploads/Ingestion Too Slow
Use when: upload or upsert API calls are slow. Identify bottleneck: client-side (network, batching) vs server-side (CPU, disk I/O)
For client-side, optimize batching and parallelism:
- Use batch upserts (64-256 points per request) Points API
- Use 2-4 parallel upload streams
For server-side, optimize Qdrant configuration and indexing strategy:
- Create more shards (3-12), each shard has an independent update worker Sharding
- Create payload indexes before HNSW builds (needed for filterable vector index) Payload index
Suitable for initial bulk load of large datasets:
- Disable HNSW during bulk load (set
indexing_threshold_kbvery high, restore after) Collection params - Setting
m=0to disable HNSW is legacy, use highindexing_threshold_kbinstead
Careful, fast unindexed upload might temporarily use more RAM and degrade search performance until optimizer catches up.
See https://qdrant.tech/documentation/manage-data/bulk-upload/
Optimizer Stuck or Taking Too Long
Use when: optimizer running for hours, not finishing.
- Check actual progress via optimizations endpoint (v1.17+) Optimization monitoring
- Large merges and HNSW rebuilds legitimately take hours on big datasets
- Check CPU and disk I/O (HNSW is CPU-bound, merging is I/O-bound, HDD is not viable)
- If
optimizer_statusshows an error, check logs for disk full or corrupted segments
HNSW Build Time Too High
Use when: HNSW index build dominates total indexing time.
- Reduce
m(default 16, good for most cases, 32+ rarely needed) HNSW params - Reduce
ef_construct(100-200 sufficient) HNSW config - Keep
max_indexing_threadsproportional to CPU cores Configuration - Use GPU for indexing GPU indexing
HNSW index for multi-tenant collections
If you have a multi-tenant use case where all data is split by some payload field (e.g. tenant_id), you can avoid building a global HNSW index and instead rely on payload_m to build HNSW index only for subsets of data.
Skipping global HNSW index can significantly reduce indexing time.
See Multi-tenant collections for details.
Additional Payload Indexes Are Too Slow
Qdrant builds extra HNSW links for all payload indexes to ensure that quality of filtered vector search does not degrade.
Some payload indexes (e.g. text fields with long texts) can have a very high number of unique values per point, which can lead to long HNSW build time.
You can disable building extra HNSW links for specific payload index and instead rely on slightly slower query-time strategies like ACORN.
Read more about disabling extra HNSW links in documentation
Read more about ACORN in documentation
What NOT to Do
- Do not create payload indexes AFTER HNSW is built (breaks filterable vector index)
- Do not use
m=0for bulk uploads into an existing collection, it might drop the existing HNSW and cause long reindexing - Do not upload one point at a time (per-request overhead dominates)
Verification and Recovery
- Replay the same dataset slice with fixed batch size and concurrency; record points/second, p95 request latency, errors, CPU, disk I/O, and optimizer completion time.
- Confirm the collection reaches its intended indexed state and run a representative search-quality check after optimization completes.
- Accept only changes that improve the bottleneck without breaching search availability, memory headroom, or durability requirements.
- On regression, stop new ingestion, restore the saved configuration, allow active optimization to settle, and rerun the baseline before retrying.
Do not disable or rebuild production indexes without a maintenance window, capacity headroom, and a tested recovery path.
Evaluation Prompts
- Normal: “A 50-million-point Qdrant import is too slow; how do I tell whether batching, disk, or HNSW construction is responsible?” Expected: establish fixed-load metrics and isolate client from server work.
- Difficult edge: “Uploads are fast, but optimizer work runs for hours and search slows during the import.” Expected: account for deferred indexing and resource competition, with rollback and completion checks.
- Should not activate: “Upserts are healthy, but filtered queries have high p99 latency.” Expected: route to search-speed optimization.
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.