Re: vector search support

2023-05-29 Thread Giuseppe Broccolo
Hi Nathan, I noticed you implemented a closest_vector function which returns the closest vector to a given one using the Euclidean distance: would it make sense to change the implementation in order to include also different distance definitions rather than the Euclidean one (for instance, cosine

Re: vector search support

2023-05-29 Thread Giuseppe Broccolo
Hi Jonathan, On 5/26/23 3:38 PM, Jonathan S. Katz wrote: > On 4/26/23 9:31 AM, Giuseppe Broccolo wrote: > > We finally opted for ElasticSearch as search engine, considering that it > > was providing what we needed: > > > > * support to store dense vectors > >

Re: vector search support

2023-04-26 Thread Giuseppe Broccolo
Hi Nathan, I find the patches really interesting. Personally, as Data/MLOps Engineer, I'm involved in a project where we use embedding techniques to generate vectors from documents, and use clustering and kNN searches to find similar documents basing on spatial neighbourhood of generated vectors.

Re: Questions about support function and abbreviate

2021-06-12 Thread Giuseppe Broccolo
Hi Han, Darafei already provided a good answer to your question, I will add just a few things with the hope of making things more clear for your use case. SortSupport implementation in PostgreSQL allows to make comparisons at binary level in a dedicated region of memory where data can be quickly

Re: Need help!

2021-04-07 Thread Giuseppe Broccolo
Hi Ayoub, Il giorno mer 7 apr 2021 alle ore 17:29 FATIHI Ayoub < ayoubfatihi1...@gmail.com> ha scritto: > Hi postgres community, > I am willing to participate in GSoC to speed up the build of the gist > index in postgis, which is based on postgresql. > And I need to know *everything* about the Gi

Re: Postgres Spark connector

2020-12-24 Thread Giuseppe Broccolo
Hi Zhihong, On Wed, 23 Dec 2020, 17:55 Zhihong Yu, wrote: > Hi, > I searched for Postgres support in Apache Spark. > I found Spark doc related to JDBC. > > I wonder if the community is aware of Spark connector for Postgres > (hopefully open source) where predicate involving jsonb columns can be

Re: Setting BLCKSZ 4kB

2018-01-16 Thread Giuseppe Broccolo
Hi Sanyam, Interesting topic! 2018-01-16 7:50 GMT+01:00 sanyam jain : > Hi, > > I am trying to solve WAL flooding due to FPWs. > > > What are the cons of setting BLCKSZ as 4kB? > > > When saw the results published on http://blog.coelho.net/ > database/2014/08/17/postgresql-page-size-for-SSD-2.ht