Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing.
pgext.cloud · Source code · Website · Documentation · License text · Control file
| Package | tsvector2 |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 10 · 11 · 12 · 13 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | public |
| Stars | 27 |
| Latest commit | 2020-10-20 |
| Latest release | 2018-12-21 |
| Catalogue updated | 2026-08-30 |
| tsearch_extras | Full-text-search helpers for returning match locations and extracting tsvector lexemes. |
| zson | Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators. |
| gunzip | Decompress gzip-compressed bytea values to text or bytea. |
| pg_deltax | Fast time-series extension for PostgreSQL |
| pg_lz4 | LZ4 compression access method for a patched PostgreSQL development branch. |
| jsonbd | Compression method for JSONB type |
| flate | Raw DEFLATE compression and decompression functions for bytea |
| zlib | zlib decompress function for PostgreSQL. |
| compress | C/C++ functions to compress text into Base64-encoded ZIP archives and extract text from them. |
| pgzstd_rs | Compress and decompress bytea values with Zstandard from PostgreSQL, including a parallel batch compressor |