compile cube extension with float4 precision storing
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
On Fri, Jun 12, 2020 at 02:41:08PM +0300, Siarhei D wrote:
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
I don't think there's a built-in support for that, so the only option I
can think of is creating your own cube "copy" extension using float4.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services