Skip to content

opensite-ai/opensite-skills / pgvector-optimization

pgvector-optimization

Verified

pgvector performance optimization: HNSW vs IVFFlat index selection and tuning, ef_search / m / ef_construction parameters, iterative scanning for filtered queries, scalar and binary quantization for memory reduction, and dimensionality compression. Embedding-model-agnostic — applies to any float32 vector workload. Use when vector search queries are slow, recall is poor, or index memory footprint is too large.

FileKindSize
SKILL.mdskill md12.2 KB
agents/openai.yamlconfig295 B
references/activation.mdmarkdown869 B
templates/index-tuning-record.mdmarkdown404 B

references/activation.md

View on GitHub
# Activation Guide

## Best-Fit Tasks
- pgvector performance optimization: HNSW vs IVFFlat index selection and tuning, ef_search / m / ef_construction parameters, iterative scanning for filtered queries, scalar and binary quantization for memory reduction, and dimensionality compression. Embedding-model-agnostic — applies to any float32 vector workload.
- Best trigger phrase: vector search queries are slow, recall is poor, or index memory footprint is too large.

## Explicit Invocation
- `Use $pgvector-optimization when vector search queries are slow, recall is poor, or index memory footprint is too large.`

## Cross-Agent Notes
- Start with `SKILL.md`, then load only the linked files you need.
- The standard metadata and this guide are portable across skills-compatible agents; Claude-specific frontmatter is optional and should degrade cleanly elsewhere.
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 197kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall