Horton

Thread

  1. Semantic cache capability for Postgresql db

    pradeep t <pradeeprajkvr@gmail.com> — 2024-07-12T13:18:33Z

    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

  2. Re: Semantic cache capability for Postgresql db

    Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-16T15:31:41Z

    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@gmail.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
>

  3. Re: Semantic cache capability for Postgresql db

    pradeep t <pradeeprajkvr@gmail.com> — 2024-07-16T15:49:07Z

    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.zeeshan@gmail.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@gmail.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

  4. Re: Semantic cache capability for Postgresql db

    Ron <ronljohnsonjr@gmail.com> — 2024-07-17T16:29:44Z

    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@gmail.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.zeeshan@gmail.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@gmail.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
>

  5. Re: Semantic cache capability for Postgresql db

    Christophe Pettus <xof@thebuild.com> — 2024-07-17T16:52:56Z

    
> 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