# Space savings on data

**URL:** <https://community.cratedb.com/t/space-savings-on-data/1338>\
**Category:** CrateDB\
**Created:** [January 26, 2023, 11:42am UTC](https://community.cratedb.com/t/space-savings-on-data/1338 "2023-01-26T11:42:34Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![hernanc](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/hernanc/32/676_2.png) [@hernanc](https://community.cratedb.com/u/hernanc)\
**Post date:** [January 26, 2023, 1:03pm UTC](https://community.cratedb.com/t/space-savings-on-data/1338/4 "2023-01-26T13:03:01Z")

</div>

Hi David,  
Apologies I missed the fact that the column needed to be part of the PK to be used for partitioning.  
Regarding the use of `ARRAY`s, I realised there was some ambiguity there.  
One possible use of `ARRAY`s would be to replace columns like `d1`, `d2`, and `d3` with a single `d` column defined as an `ARRAY`.  
A different use of `ARRAY`s would be what is described in [Optimizing storage for historic time-series data - Tutorials - CrateDB Community](https://community.cratedb.com/t/optimizing-storage-for-historic-time-series-data/762) , you may find the approach described in that article interesting if it is something you had not seen before.

---

_[View the full topic](https://community.cratedb.com/t/space-savings-on-data/1338)._
