# Community Edition 4.0.10 as prometheus remote storage, data takes up too much space

**URL:** <https://community.cratedb.com/t/community-edition-4-0-10-as-prometheus-remote-storage-data-takes-up-too-much-space/319>\
**Category:** CrateDB\
**Created:** [January 20, 2020, 6:04am UTC](https://community.cratedb.com/t/community-edition-4-0-10-as-prometheus-remote-storage-data-takes-up-too-much-space/319 "2020-01-20T06:04:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cheng](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@cheng](https://community.cratedb.com/u/cheng)\
**Post date:** [January 20, 2020, 6:04am UTC](https://community.cratedb.com/t/community-edition-4-0-10-as-prometheus-remote-storage-data-takes-up-too-much-space/319/1 "2020-01-20T06:04:42Z")

</div>

**version:**  
Community Edition 4.0.10

**configuration:**  
#docker-compose.yml  
version: ‘3.2’

services:  
crate:  
image: implustechnology/crate-ce:4.0.10  
restart: always  
hostname: prometheus-db-1  
container\_name: crate  
network\_mode: host  
volumes:  
- “/opt/data/crate:/data”  
command:  
- crate  
- -Ccluster.name=cratecluster  
- -Cnode.name=prometheus-db-1  
- -Cnode.master=true  
- -Cnode.data=true  
- -Chttp.port=5201  
- -Cpsql.port=5210  
- -Ctransport.tcp.port=5202  
- -Cnetwork.host=prometheus-db-1  
- -Cdiscovery.seed\_hosts=prometheus-db-2,prometheus-db-3  
- -Ccluster.initial\_master\_nodes=prometheus-db-1,prometheus-db-2,prometheus-db-3  
- -Cgateway.expected\_nodes=3  
- -Cgateway.recover\_after\_nodes=2  
- -Chttp.cors.enabled=true  
- -Chttp.cors.allow-origin="\*"  
- -Cgateway.recover\_after\_time=1m  
environment:  
- CRATE\_HEAP\_SIZE=2g

**data size:**  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/crate/original/1X/47783fd9747076ce5ec3d07ce966e719ceebc8df.png)

how to optimize data size?

---

<div class="post-metadata">

**Author:** ![joemoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/joemoe/32/65_2.png) [@joemoe](https://community.cratedb.com/u/joemoe)\
**Post date:** [January 22, 2020, 7:03am UTC](https://community.cratedb.com/t/community-edition-4-0-10-as-prometheus-remote-storage-data-takes-up-too-much-space/319/2 "2020-01-22T07:03:22Z")

</div>

hi, you can turn off some indexes especially on the labels\_hash.  
given the query speed benefit you get with cratedb 0.25 kb per record inlcuding all kind of indexing is not too much tbh.  
you could also tweek the labels object if you are already aware of them upfront.

> **[crate/crate\_adapter](https://github.com/crate/crate_adapter#usage)**
>
> CrateDB Prometheus Adapter. Contribute to crate/crate\_adapter development by creating an account on GitHub.

  
[https://crate.io/docs/crate/reference/en/latest/general/ddl/fulltext-indices.html#disable-indexing](https://crate.io/docs/crate/reference/en/latest/general/ddl/fulltext-indices.html#disable-indexing)

---

<div class="post-metadata">

**Author:** ![cheng](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@cheng](https://community.cratedb.com/u/cheng)\
**Post date:** [February 3, 2020, 6:13am UTC](https://community.cratedb.com/t/community-edition-4-0-10-as-prometheus-remote-storage-data-takes-up-too-much-space/319/3 "2020-02-03T06:13:40Z")

</div>

When I disable labels\_hash index, I get with cratedb about 0.20 kb per record, but the data size is still big.

Are there any other ways to compress data size?