3 ms·
Curious if he could squeeze more performance by using a different structure to store the same data. Some of these float4 cols could probably be stored as int2.
by koliber 3y ago
Curious if he could squeeze more performance by using a different structure to store the same data. Some of these float4 cols could probably be stored as int2. Depending on how many decimal places are needed, can divide the int to get the resulting floating point value.
- PolarizedPoutin 3y agoYeah I was thinking about this and hoped that Postgres had a `float2` data type but `int2` would have to work. I could scale the numbers to fit them into 2 bytes with minimal loss of precision, but decided I'd rather take the storage space hit since TimescaleDB promises good compression. Still haven't measured this though haha.