public inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Pratik Pandit <pratikpandit5322@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension)
Date: Wed, 20 May 2026 17:56:08 +0530
Message-ID: <CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA@mail.gmail.com> (raw)

Hi everyone,

I am looking to handle document-store workloads directly inside PostgreSQL,
but using MongoDB-style query patterns or optimized storage structures.

To give an analogy: I  highly appreciate how pgvector brings native vector
data types and specialized indexing (like HNSW) directly into Postgres,
keeping everything inside the same database engine.
I know Postgres has incredible jsonb capabilities natively, but I am
looking for a PostgreSQL extension that bridges the gap closer to MongoDB.
Specifically, I'm hoping to find something that provides:
1. A Native BSON Data Type: Storing binary JSON natively inside Postgres
for faster processing.
2. MongoDB API/Query Compatibility: The ability to run Mongo-like queries
directly on top of Postgres tables.

I am already aware of Foreign Data Wrappers like mongo_fdw, but that is for
querying a separate, external MongoDB instance. I want to keep the
data *natively
resident* inside Postgres.

Are there any active open-source extensions or projects that the community
recommends for this? (I have heard brief mentions of things like
pg_documentdb / FerretDB, but I'd like to get the community's perspective
on what is production-ready extension for it).

Best regards,

Pratik Pandit

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pratikpandit5322@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Looking for a native MongoDB document extension for PostgreSQL (similar to pgvector like extension)
  In-Reply-To: <CAFchsDVMBwPJfSGkVqhwygKTJP-DqarwTyuqyvzVsKgBtKabxA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox