Results for “payload-index”

Guides database index selection, creation, and maintenance with SQL examples for PostgreSQL and MySQL.

Diagnoses and tunes PostgreSQL performance issues such as slow queries, missing indexes, bloat, locks, and connection problems, providing SQL commands and best practices.

Read and query onchain data using events, The Graph, Dune, Ponder, Multicall3, and WebSocket subscriptions, with guidance on block iteration limitations.

Designs Elasticsearch indexes and mappings, tunes queries, sizes clusters, and handles operations like shard/replica strategy, ILM, monitoring, troubleshooting, and safe reindexing or upgrades.

Pulls pathway, book, course, article, and content item records from a Supabase database for the alan-hirsch tenant, organizes them by portal, and exports the results as markdown files into a local docs repository.

Diagnoses and resolves slow Qdrant search performance issues including high latency, low throughput, and slow filtered searches.