Обсуждение: 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