compile cube extension with float4 precision storing

From: Siarhei D <siarhei(dot)damanau(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: compile cube extension with float4 precision storing
Date: 2020-06-12 11:41:08
Message-ID: CAGqr3QtV_k5G0-8AeoXckVwO7UV8PMR0JJGizd3A8Ay9BreZ5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Is it possible to make cube extension with float(4bytes) precision instead
of double(8bytes)?

I use cube extension for storing embedding vectors and calculation distance
on them. During comparing vectors, a 4byte float precision is enough.
Storing 8 byte double precision is wasting disk space.

Now to avoid disk wasting I store vectors as real[] array and create cube
objects on the fly. But this solution is wasting cpu time

--

Siarhei Damanau

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Juan José Santamaría Flecha 2020-06-12 12:02:52 Re: TAP tests and symlinks on Windows
Previous Message Ashutosh Sharma 2020-06-12 11:27:40 Re: Parallel copy