You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In cases where people want to store arrays of data, for instance, when storing a series of measurements associated with a single time point - for instance, if you want to store vibration or UV spectral data, it's not necessarily true that each measurement has a timestamp associated with it, rather, many measurements are taken with (essentially) a single timestamp or are always evaluated together. You can store this in a normal PG array, but you never get the value of compression if you do that, because we can't compress arrays, and PG array compression is much worse than ours.
Describe the solution you'd like
A compressed array interface that can be stored and is available to users. At first it would just provide the same interface as a normal PG array, but eventually you might be able to do some actions (aggregates etc) on the array directly for performance reasons.
The text was updated successfully, but these errors were encountered:
In cases where people want to store arrays of data, for instance, when storing a series of measurements associated with a single time point - for instance, if you want to store vibration or UV spectral data, it's not necessarily true that each measurement has a timestamp associated with it, rather, many measurements are taken with (essentially) a single timestamp or are always evaluated together. You can store this in a normal PG array, but you never get the value of compression if you do that, because we can't compress arrays, and PG array compression is much worse than ours.
Describe the solution you'd like
A compressed array interface that can be stored and is available to users. At first it would just provide the same interface as a normal PG array, but eventually you might be able to do some actions (aggregates etc) on the array directly for performance reasons.
The text was updated successfully, but these errors were encountered: