Social Media Ideas for Indexing

Vector Database Indexing Explained: Why It Matters More Than the Embeddings Themselves

Most conversations about vector databases start and end with embeddings. Discussions typically center around how they're generated, which model produced them, how many dimensions t...

How Sorting, Indexing, and Temporary Storage Impact Database Performance

Many database (DB) queries rely on indexing, sorting, and temporary storage during query execution. These elements need to be well-aligned to ensure queries return results quickly...

Trustless Indexing Arrived: What It Costs Prediction Markets

Willow just posted a verifiable proof on-chain confirming that a sequence of Ethereum blocks was indexed completely and correctly, at a…Continue reading on Medium »

$1 Million Direct Indexing: Single Stock Versus Sector Fund Strategies

Индекс как алфавитный указатель: как база ищет и почему иногда не находит

В первой статье я объяснял кэш через холодильник. Продолжу тем же способом. Сейчас будет про индексы, а потом про то, почему индекс есть, а база его игнорирует.Статья для тех, кто...

Indexing on Solana in Rust: Streaming, Decoding, and Proving Completeness

Built with Yellowstone gRPC and Carbon. 12.4 million Pump.fun and PumpSwap trades over 12 hours of mainnet.Continue reading on Medium »

Your Blockchain Indexer Is Fine — Until It Isn’t

What nobody tells you about hitting 20–30 TB of indexed blockchain data, and why “just optimize it later” is the most expensive sentence…Continue reading on Medium »

Индексируем диапазоны с помощью битовых масок, чтобы k8s не ломал индекс

Привет, это Антон Пионтковский из команды Monium Metrics, и вместе с коллегами мы создаём observability‑платформу для сбора, хранения и анализа телеметрии Yandex Monium. Мы храним...

Selection Indexes – Understanding and Reviewing

How selection indexes are developed, what they represent and how reviews can ensure they remain commercially relevant, particularly in light of the recently announced Brahman index...

Как быстро загнать страницу в индекс Яндекса — и почему для Алисы AI этого мало

Новую страницу в поиске Яндекса не видно, пока её не обошёл робот. Пока страницы нет в индексе (базе поиска), её не будет ни в обычной выдаче, ни в ответе Алисы AI. Алиса опирается...

Updating my Watch Site for Algolia Support

Alright, so I was supposed to share this a bit quicker, but life, work, etc, kept me busy. I've had this particular change up for a few days but I'm just now getting around to blog...

Direct Indexing, Structured Notes Help Advisors Manage Index Fund Concentration Risk

Wealth managers deploy long-short strategies, structured notes and stock picking to shield clients from overvalued large caps in ETFs and mutual funds.

CORE INDEX and New Trading Systems

Apple says these three things can speed up the new Spotlight indexing

Apple has published a new support document explaining how Spotlight indexing works across its devices, including three things it says can help the process finish more quickly. Here...

Pixel-Native RAG: A Practical Guide to Visual Document Indexing

Move beyond traditional text-based parsing with PixelRAG, an end-to-end system that treats web pages and PDFs as images. This tutorial explores the complete pipeline—from renderi...

From Sphinx to PostgreSQL full text search

Originally appeared on Junior Developer.Way back in 2008 I started a site to track military reading lists. I needed something for searching, and I was most familiar with Sphinx...

Database Animations: How Index Seeks Work

In my free How to Think Like the Engine class, I gloss over the entire concept of B-trees and just hand-wavily say “SQL Server can seek to the page that has the row you’re looking...

Apple reveals how to speed up Spotlight indexing on iPhone and Mac

Apple explains why Spotlight indexing can take days after an update and how to speed up the process on your iPhone, iPad or Mac. (via Cult of Mac - Your source for the latest Apple...

How GPU acceleration builds billion-scale vector indexes on Amazon OpenSearch Service

GPU-accelerated vector (k-NN) indexing on Amazon OpenSearch Service and OpenSearch Serverless lets you build billion-scale vector indexes in hours instead of days. This post goes d...

Pimcore Reindex: Fix Objects Missing After Import

You ran an import. The rows landed in the database. But your Pimcore imported objects are not visible in Studio, and a Pimcore reindex is what you actually need. The tree is empty,...

Store and search chunks in Laravel with Meilisearch and Larameili

Many times, you have to split documents into chunks, embed them, and push them into Meilisearch. Now the chunks live in the index and only in the index. There is no reason to keep...

Database Bottlenecks Nobody Talks About: Optimizing SQL Queries Beyond Indexing

Every performance guide starts the same way. "Add an index." And yes, indexes matter. But I've spent years fixing production databases, and here's the truth: indexing is the easy 2...

Your pgvector Search Gets Slower as You Add Data. Here’s the Setting Everyone Misses.

<p class="wp-block-paragraph">Your semantic search was instant at ten thousand rows. At two million it’s 800 milliseconds and climbing, and you never</...

Building Production-Ready AI Vector Search in Databricks: Chunking, Embeddings, ML Pipelines, and RAG

The demo always works. You paste a PDF into a notebook, split it into chunks, embed them with a hosted model, push the vectors into an index, and ask a question. The answer comes b...