prorm API Reference
    Preparing search index...

    Enumeration IndexMethod

    The index structure to build.

    Which of these an engine offers varies: B-tree is universal, the rest are mostly PostgreSQL. Asking for one an engine lacks is reported by the dialect rather than silently ignored.

    Index
    BTree: "btree"

    The default, and the only one every engine has. Ordered, so it serves equality, ranges, sorting and prefix matching alike.

    Hash: "hash"

    Equality only, and smaller than a B-tree for that one job.

    Gin: "gin"

    Generalised inverted index — arrays, JSONB, full-text.

    Gist: "gist"

    Generalised search tree — geometric and range types.

    SpGist: "spgist"

    Space-partitioned GiST: for data that divides into non-overlapping regions, such as points or text prefixes.

    Brin: "brin"

    Block range index: small, for naturally ordered columns.