pg_kazsearch

Overview

Upstream release/package version is 2.0.0; extension control version is 0.1.0.

Version

Build

You can build the RPM / DEB packages for pg_kazsearch using pig build:

pig build pkg pg_kazsearch         # build RPM / DEB packages

Install

You can install pg_kazsearch directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

• Install
• pig
• dnf
• apt

pig install pg_kazsearch;          # Install for current active PG version

pig ext install -y pg_kazsearch -v 18  # PG 18
pig ext install -y pg_kazsearch -v 17  # PG 17
pig ext install -y pg_kazsearch -v 16  # PG 16

dnf install -y pg_kazsearch_18       # PG 18
dnf install -y pg_kazsearch_17       # PG 17
dnf install -y pg_kazsearch_16       # PG 16

apt install -y postgresql-18-pg-kazsearch   # PG 18
apt install -y postgresql-17-pg-kazsearch   # PG 17
apt install -y postgresql-16-pg-kazsearch   # PG 16

Create Extension:

CREATE EXTENSION pg_kazsearch;

Usage

Sources: README and project repo.

pg_kazsearch is a PostgreSQL full-text search extension for the Kazakh language. The upstream README describes it as a Rust extension built with pgrx that plugs into PostgreSQL’s text search pipeline.

It creates a ready-to-use configuration named kazakh_cfg and the supporting dictionary pg_kazsearch_dict.

Quick Start

CREATE EXTENSION pg_kazsearch;

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

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

Use Cases

The README shows the extension being used for:

• stemming individual Kazakh words
• building tsvector values with to_tsvector('kazakh_cfg', ...)
• adding generated tsvector columns to a table
• indexing those columns with GIN
• searching with websearch_to_tsquery('kazakh_cfg', ...)

Example table workflow:

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

Penalty weights are adjustable at runtime:

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

Deployment

The README documents three supported paths:

• pre-built Debian/Ubuntu packages
• a Docker image based on ghcr.io/darkhanakh/pg-kazsearch
• source builds with cargo pgrx install

The repository metadata in this project matches PostgreSQL 16-18.