Re: Semantic cache capability for Postgresql db

Lists: pgsql-general
From: pradeep t <pradeeprajkvr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Semantic cache capability for Postgresql db
Date: 2024-07-12 13:18:33
Message-ID: CAFQWw-YTxSLGG-i5cf-2TRxB40rHefeHHA2jicKosM_La6WFSA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

Hi,

Shall I use the Postgresql database for a* semantic cache *like the Redis
semantic cache?
Are we currently supporting such usage?

--
Thanks and regards
Pradeep.T

From: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
To: pradeep t <pradeeprajkvr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Semantic cache capability for Postgresql db
Date: 2024-07-16 15:31:41
Message-ID: CAAPsdheoEhMKemb414C_J-VjEAXHmGZu0fgrq2HOU28O5ULAWw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

Hi Pradeep

pgprewarm Extension is available for Postgres

https://www.postgresql.org/docs/current/pgprewarm.html

On Tue, Jul 16, 2024 at 7:05 PM pradeep t <pradeeprajkvr(at)gmail(dot)com> wrote:

> Hi,
>
> Shall I use the Postgresql database for a* semantic cache *like the Redis
> semantic cache?
> Are we currently supporting such usage?
>
> --
> Thanks and regards
> Pradeep.T
>

From: pradeep t <pradeeprajkvr(at)gmail(dot)com>
To: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Semantic cache capability for Postgresql db
Date: 2024-07-16 15:49:07
Message-ID: CAFQWw-YDEFKLHnEz_-DsD-6m_VJCupqOvQNHsmQRQL_Ub_67eg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

Thanks, I'll check it out.
Also is there any python client for the connection to pgprewarm?
Is the existing Postgresql python client will support the pgprewarm cache
usage also?

On Tue, Jul 16, 2024 at 9:01 PM Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
wrote:

> Hi Pradeep
>
> pgprewarm Extension is available for Postgres
>
> https://www.postgresql.org/docs/current/pgprewarm.html
>
>
>
> On Tue, Jul 16, 2024 at 7:05 PM pradeep t <pradeeprajkvr(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> Shall I use the Postgresql database for a* semantic cache *like the
>> Redis semantic cache?
>> Are we currently supporting such usage?
>>
>> --
>> Thanks and regards
>> Pradeep.T
>>
>

--
Thanks and regards
Pradeep.T

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Semantic cache capability for Postgresql db
Date: 2024-07-17 16:29:44
Message-ID: CANzqJaCUrnbk4qe7NZh5K1M=jtaJKUi1O0i0Bsv0PT4bFytFxg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

What does "python client will support the pgprewarm cache usage" mean?

Read the pgprewarm docs.

On Wed, Jul 17, 2024 at 11:10 AM pradeep t <pradeeprajkvr(at)gmail(dot)com> wrote:

> Thanks, I'll check it out.
> Also is there any python client for the connection to pgprewarm?
> Is the existing Postgresql python client will support the pgprewarm cache
> usage also?
>
> On Tue, Jul 16, 2024 at 9:01 PM Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
> wrote:
>
>> Hi Pradeep
>>
>> pgprewarm Extension is available for Postgres
>>
>> https://www.postgresql.org/docs/current/pgprewarm.html
>>
>>
>>
>> On Tue, Jul 16, 2024 at 7:05 PM pradeep t <pradeeprajkvr(at)gmail(dot)com>
>> wrote:
>>
>>> Hi,
>>>
>>> Shall I use the Postgresql database for a* semantic cache *like the
>>> Redis semantic cache?
>>> Are we currently supporting such usage?
>>>
>>> --
>>> Thanks and regards
>>> Pradeep.T
>>>
>>
>
> --
> Thanks and regards
> Pradeep.T
>

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: pradeep t <pradeeprajkvr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Semantic cache capability for Postgresql db
Date: 2024-07-17 16:52:56
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

> On Jul 12, 2024, at 06:18, pradeep t <pradeeprajkvr(at)gmail(dot)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