Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Semantic cache capability for Postgresql db
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAFQWw-YTxSLGG-i5cf-2TRxB40rHefeHHA2jicKosM_La6WFSA@mail.gmail.com>
Date: Wed, 17 Jul 2024 09:52:56 -0700
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <780CAA1B-35B8-4B7D-9D12-3786B2FB264D@thebuild.com>
References: <CAFQWw-YTxSLGG-i5cf-2TRxB40rHefeHHA2jicKosM_La6WFSA@mail.gmail.com>
To: pradeep t <pradeeprajkvr@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/780CAA1B-35B8-4B7D-9D12-3786B2FB264D%40thebuild.com>
Precedence: bulk


> On Jul 12, 2024, at 06:18, pradeep t <pradeeprajkvr@gmail.com> wrote:
> Shall I use the Postgresql database for a semantic cache like the =
Redis semantic cache?

If you mean this feature:

	=
https://redis.io/docs/latest/integrate/redisvl/user-guide/semantic-caching=
/

... there is no direct equivalent in PostgreSQL.  This is something =
you'd have to implement on top of PostgreSQL's existing extensions, such =
as pgvector:

	https://github.com/pgvector/pgvector=