arunmu

Thanks. I wish you had gone into more details on why recall was bad and what scale etc so that current users could also identify their issues. Also, it seems the new index is memory based and does not scale on machines with lower memory by being built on disk data structure ?

Didn't these guys also write pgvectorscale which seems to be unmaintained now ? Why a new index instead of adding onto or improving pgvectorscale?

Were you using it for simple grep search or actually required advanced searching for eg: BM25. Clickhouse will only help you with grep like search from what I understand.

There is pgvectorscale from timescale which uses disk ann based data structure and has support for pre and post filtering.

Thanks. We are already using timescale postgres image for pgvectorscale with some customizations on tsvector and GIN indexes. Would be nice to have bm25 as well. Any specific reason why this was not made open source from the get go or is it the usual phased approach by Timescale (now Tigerdata)? If not, it is a worrying signal as the same could happen with pgvectorscale development as well.

Anyways really appreciate the free offerings by timescale. Really makes things easy.

I would very much like it if it was opensourced like pgvectorscale and timescale extension itself

I am a big fan of cloudflare blogs. The tech blogs are usually highly detailed and there is so much to learn from those.

But this one, interesting but was not a practical choice at all from what I gather reading the blog. The reason given for not using Clickhouse which they are already using for analytics was vague and ambiguous. Clickhouse does support JSON which can be re-written into a more structured table using MV. Aggregation and other performance tuning steps are bread and butter of using Clickhouse.

The decision to go with postgres and learn the already known limitations the hard way and then continue using it by bringing up a new technology (Timescale) does not sound good, assuming that Cloudflare at this point might already have lots of internal tools for monitoring clickhouse clusters.

Thanks. I would have preferred to use Go instead of Python, but somehow the language is not picking up a lot in terms of new LLM frameworks.

As of now, I am using very light weight abstractions over prompts in python and that gets the job done. But, it is way too early and I can see how pipelining multiple LLM calls would need a good library that is not too complex and involved. In the end it is just a API call and you hope for the best result :)

> No LangChain, no LangGraph, no LlamaIndex, no CrewAI

Bless you. Using these over complicated abstractions (except CrewAI which I haven't yet checked out) never made sense to me. I understand that LLM is no magic wand and there is a need to make it systematic rather than slapping prompts everywhere. But these frameworks are not the solution to it. Next I will be looking at is Microsofts semantic-kernel. Anybody has any good words for it ?

I wonder why not clickhouse. Cloudflare has already deployed a lot of analytics services based on CH. Would have been nice if they could provide more details on that.