Part III : The Delivery Layer
The Trade-Off
PIGSTY
C Extension:Fast and Small
Rust Extension:Slow and Bulky
| Name | Star | RPM / DEB Package | Avg Size | Description |
|---|---|---|---|---|
| pg_search | 8,783 | pg_search_$v / postgresql-$v-pg-search | 56.8 MB | Full text search for PostgreSQL using BM25 |
| pg_tokenizer | 43 | pg_tokenizer_$v / postgresql-$v-pg-tokenizer | 10.7 MB | Tokenizers for full-text search |
| pg_analytics | 537 | pg_analytics_$v / postgresql-$v-pg-analytics | 9.92 MB | Postgres for analytics, powered by DuckDB |
| pg_mooncake | 1,965 | pg_mooncake_$v / postgresql-$v-pg-mooncake | 9.47 MB | Columnstore Table in Postgres |
| pg_bestmatch | 96 | pg_bestmatch_$v / postgresql-$v-pg-bestmatch | 6.59 MB | Generate BM25 sparse vector inside PostgreSQL |
| vectorize | 831 | pg_vectorize_$v / postgresql-$v-pg-vectorize | 6.51 MB | The simplest way to do vector search on Postgres |
| pg_parquet | 670 | pg_parquet_$v / postgresql-$v-pg-parquet | 6.39 MB | copy data between Postgres and Parquet |
| pgml | 6,789 | pgml_$v / postgresql-$v-pgml | 4.97 MB | Run AL/ML workloads with SQL interface |
| pg_trickle | 107 | pg_trickle_$v / postgresql-$v-pg-trickle | 3.70 MB | Streaming tables and differential view maintenance for PostgreSQL 18 |
| tzf | 8 | pg_tzf_$v / postgresql-$v-tzf | 3.48 MB | Fast lookup timezone name by GPS coordinates |
| anon | 0 | pg_anon_$v / postgresql-$v-pg-anon | 2.89 MB | PostgreSQL Anonymizer (anon) extension |
| timescaledb_toolkit | 470 | timescaledb-toolkit_$v / postgresql-$v-timescaledb-toolkit | 2.84 MB | Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities |
| plprql | 473 | plprql_$v / postgresql-$v-plprql | 2.38 MB | Use PRQL in PostgreSQL - Pipelined Relational Query Language |
| vchord | 1,680 | vchord_$v / postgresql-$v-vchord | 2.05 MB | Vector database plugin for Postgres, written in Rust |
| etcd_fdw | 4 | etcd_fdw_$v / postgresql-$v-etcd-fdw | 1.49 MB | Foreign data wrapper for etcd |
| pg_tiktoken | 52 | pg_tiktoken_$v / postgresql-$v-pg-tiktoken | 1.49 MB | tiktoken tokenizer for use with OpenAI models in postgres |
| pgmqtt | 3 | pgmqtt_$v / postgresql-$v-pgmqtt | 1.44 MB | CDC-to-MQTT broker for PostgreSQL |
| pg_pinyin | 10 | pg_pinyin_$v / postgresql-$v-pinyin | 1.36 MB | Pinyin romanization and search helpers for PostgreSQL |
| pg_later | 373 | pg_later_$v / postgresql-$v-pg-later | 1.26 MB | Run queries now and get results later |
| pg_jsonschema | 1,188 | pg_jsonschema_$v / postgresql-$v-pg-jsonschema | 1.19 MB | PostgreSQL extension providing JSON Schema validation |
| pglite_fusion | 826 | pglite_fusion_$v / postgresql-$v-pglite-fusion | 1.11 MB | Embed an SQLite database in your PostgreSQL table |
| pg_render | 65 | pg_render_$v / postgresql-$v-pg-render | 0.92 MB | Render HTML in SQL |
| pg_summarize | 6 | pg_summarize_$v / postgresql-$v-pg-summarize | 0.91 MB | Text Summarization using LLMs. Built using pgrx |
| explain_ui | 5 | pg_explain_ui_$v / postgresql-$v-pg-explain-ui | 0.91 MB | easily jump into a visual plan UI for any SQL query |
| pg_graphql | 3,326 | pg_graphql_$v / postgresql-$v-pg-graphql | 0.72 MB | Add in-database GraphQL support |
| pgsmcrypto | 15 | pgsmcrypto_$v / postgresql-$v-pgsmcrypto | 0.70 MB | PostgreSQL SM Algorithm Extension |
| pg_enigma | 11 | pg_enigma_$v / postgresql-$v-enigma | 0.63 MB | Encrypted postgres data type |
| pglinter | 167 | pglinter_$v / postgresql-$v-pglinter | 0.47 MB | PostgreSQL Linting and Analysis Extension |
| pg_smtp_client | 10 | pg_smtp_client_$v / postgresql-$v-pg-smtp-client | 0.43 MB | PostgreSQL extension to send email using SMTP |
| vchord_bm25 | 368 | vchord_bm25_$v / postgresql-$v-vchord-bm25 | 0.42 MB | A postgresql extension for bm25 ranking algorithm |
| vectorscale | 3,017 | pgvectorscale_$v / postgresql-$v-pgvectorscale | 0.41 MB | Advanced indexing for vector data with DiskANN |
| pg_cardano | 2 | pg_cardano_$v / postgresql-$v-pg-cardano | 0.41 MB | A suite of Cardano-related tools |
| pg_idkit | 424 | pg_idkit_$v / postgresql-$v-pg-idkit | 0.37 MB | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) |
| pg_when | 44 | pg_when_$v / postgresql-$v-pg-when | 0.35 MB | Natural language time parsing for PostgreSQL |
| pg_session_jwt | 65 | pg_session_jwt_$v / postgresql-$v-pg-session-jwt | 0.34 MB | Manage authentication sessions using JWTs |
| pg_kazsearch | 22 | pg_kazsearch_$v / postgresql-$v-pg-kazsearch | 0.34 MB | Kazakh full-text search extension for PostgreSQL |
| typeid | 22 | pg_typeid_$v / postgresql-$v-typeid | 0.31 MB | Allows to use TypeIDs in Postgres natively |
| pgx_ulid | 499 | pgx_ulid_$v / postgresql-$v-pgx-ulid | 0.30 MB | ulid type and methods |
| pg_strict | 18 | pg_strict_$v / postgresql-$v-pg-strict | 0.25 MB | Prevent dangerous UPDATE and DELETE without WHERE clause |
| pg_polyline | 4 | pg_polyline_$v / postgresql-$v-pg-polyline | 0.24 MB | Fast Google Encoded Polyline encoding & decoding for postgres |
| pg_rrf | 3 | pg_rrf_$v / postgresql-$v-pg-rrf | 0.23 MB | Reciprocal rank fusion functions for hybrid search |
| pg_command_fw | 1 | pg_command_fw_$v / postgresql-$v-pg-command-fw | 0.23 MB | DDL and utility command firewall for PostgreSQL |
| pg_eviltransform | 8 | pg_eviltransform_$v / postgresql-$v-eviltransform | 0.23 MB | Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform |
| block_copy_command | 3 | block_copy_command_$v / postgresql-$v-block-copy-command | 0.22 MB | Block COPY commands via a configurable ProcessUtility hook |
| pg_base58 | 2 | pg_base58_$v / postgresql-$v-pg-base58 | 0.22 MB | Base58 Encoder/Decoder Extension for PostgreSQL |
| convert | 3 | pg_convert_$v / postgresql-$v-convert | 0.20 MB | conversion functions for spatial, routing and other specialized uses |
| pgdd | 55 | pgdd_$v / postgresql-$v-pgdd | 0.20 MB | Introspect pg data dictionary via standard SQL |
| wrappers | 845 | wrappers_$v / postgresql-$v-wrappers | 0.18 MB | Foreign data wrappers developed by Supabase |