pg_kazsearch

pg_kazsearch : Kazakh full-text search extension for PostgreSQL

Overview

Packages

Source

pig build pkg pg_kazsearch;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_kazsearch;		# install via package name, for the active PG version

pig install pg_kazsearch -v 18;   # install for PG 18
pig install pg_kazsearch -v 17;   # install for PG 17
pig install pg_kazsearch -v 16;   # install for PG 16

Create this extension with:

CREATE EXTENSION pg_kazsearch;

Usage

Sources: README, v2.0.0 release, v2.1.0 release

pg_kazsearch is a PostgreSQL full-text search extension for the Kazakh language. The README says it supports PostgreSQL 16-18 and creates a ready-to-use text search configuration kazakh_cfg and dictionary pg_kazsearch_dict.

Quick start

CREATE EXTENSION pg_kazsearch;

SELECT ts_lexize('pg_kazsearch_dict', 'алмаларымыздағы');
-- {алма}

SELECT to_tsvector('kazakh_cfg', 'президенттің жарлығы');
-- 'жарлық':2 'президент':1

Add Kazakh FTS to a table

ALTER TABLE articles ADD COLUMN fts tsvector
    GENERATED ALWAYS AS (
        setweight(to_tsvector('kazakh_cfg', title), 'A') ||
        setweight(to_tsvector('kazakh_cfg', body), 'B')
    ) STORED;

CREATE INDEX idx_fts ON articles USING GIN (fts);

SELECT title
FROM articles
WHERE fts @@ websearch_to_tsquery('kazakh_cfg', 'президенттің жарлығы')
ORDER BY ts_rank_cd(fts, websearch_to_tsquery('kazakh_cfg', 'президенттің жарлығы')) DESC
LIMIT 10;

Tuning

The README documents runtime dictionary tuning without restart:

ALTER TEXT SEARCH DICTIONARY pg_kazsearch_dict
  (w_deriv = 3.5, w_short_char = 100.0);

Release and packaging notes

• This project’s CSV tracks extension control version 0.1.0, package/source version 2.0.0, pgrx 0.17.0, and PostgreSQL versions 16-18.
• Upstream release v2.0.0 introduced the current Rust / pgrx PostgreSQL extension packaging.
• Upstream release v2.1.0 adds an Elasticsearch plugin alongside the PostgreSQL extension; the PostgreSQL SQL usage in the README is unchanged.

Caveat

The PostgreSQL-facing docs are concise and focused on stemming plus FTS usage. For this stub, avoid inferring extra SQL objects beyond kazakh_cfg, pg_kazsearch_dict, and the documented examples above.