Overview

ParadeDB ships all of its functionality via Postgres extensions. All updates to ParadeDB can be received by updating one or more of the following extensions:

  1. pg_analytics for accelerated analytical queries
  2. pg_bm25 for full text search
  3. pgvector for dense vector search
  4. pg_sparse for sparse vector search

Getting the Current Version

To inspect the current version of an extension, run the following command.

SELECT extversion FROM pg_extension WHERE extname = '<extension_name>';

Updating to a New Version

If a new version of pg_bm25 or pg_sparse is available, it will be listed in the changelog. Here, you can view the changes made and decide if you want to upgrade. Note that some updates may alter an extension’s API interface.

The latest pg_bm25 and pg_sparse will always be pegged to the same version. pgvector, on the other hand, is created and maintained outside of ParadeDB, so it maintains its own version. Users should refer to the pgvector README for documentation on its latest changes.

From ParadeDB Cloud

Run the following command to upgrade to a specific version of an extension.

ALTER EXTENSION <extension_name> UPDATE TO '<version_number>';

From ParadeDB Docker Image

Run the following command to pull a specific version of the Docker Image. You can set the version number to latest to pull the latest Docker image.

docker pull paradedb/paradedb:<version_number>

From Self-Managed Postgres

First, download and install the extension you wish to upgrade in the same way that it was initially installed. Then, run

ALTER EXTENSION <extension_name> UPDATE TO '<version_number>';