Faster Counts

This feature is available in versions 0.26.2 and above. Indexes built before 0.26.2 must be rebuilt to receive this optimization.

ParadeDB can speed up eligible COUNT(*) queries that combine common search terms with AND or OR by storing additional bitmap structures.

Index Configuration

The bitmap_postings option on a tokenizer cast defaults to true. It is enabled by default because the storage overhead is usually very small. If your workload does not require counts, you can disable it for a field with bitmap_postings=false:

CREATE INDEX search_idx ON mock_items
USING paradedb (id, (description::pdb.unicode_words('bitmap_postings=false')), category);

Indexing

Full-Text / Lexical Search

Vector / Semantic Search

Hybrid Search

Aggregations

JOINs

Sharding

Cheatsheets

Index Configuration

​Index Configuration

Index Configuration