Resource recommendations

This section describes the compute and disk requirements that are recommended for Promscale, based on the ingest rate and retention.

Disk size per day: disk consumption per day based on the ingest rate.

Uncompressed buffer: disk consumed by uncompressed data before compression.

Total disk size: size of disk required to store the data based on the ingest rate and retention.

note

You can calculate the total disk size based on retention and ingest rates with this formula:

Total disk size = (Disk size per day based on the ingest rate * Retention in days) + Uncompressed buffer based on the ingest rate.

Metrics

Resource recommendation for ingestion using Prometheus remote-write.

Prometheus remote write

For optimal performance of remote_write to Promscale, use this Prometheus remote_write configuration:

  1. remote_write:
  2. remote_timeout: 100s
  3. queue_config:
  4. capacity: 100000
  5. max_samples_per_send: 10000
  6. batch_send_deadline: 30s
  7. min_shards: 20
  8. max_shards: 20
  9. min_backoff: 100ms
  10. max_backoff: 10s

Compute recommendations for the Promscale connector and TimescaleDB are:

Ingestion RateConnector CPUConnector MemoryDB CPUDB MemoryDB connections
10k samples/sec0.5250 MB14 GB1
50k samples/sec2700 MB416 GB2
100k samples/sec42 GB832 GB4
200k samples/sec84.5 GB1664 GB8

Disk recommendations for TimescaleDB are:

The default chunk interval is 8h

Ingest rateRetentionDisk size per dayUncompressed bufferTotal disk sizeWAL size
10k samples/sec90 days~2 GB~21 GB~200 GB1.25 GB
50k samples/sec90 days~10 GB~105 GB~1 TB-
100k samples/sec90 days~20 GB~210 GB~2 TB-
200k samples/sec90 days~40 GB~420 GB~4 TB-

Traces

Resource recommendation for ingestion through OTLP (OpenTelemetry Line Procotol) gRPC endpoint.

OpenTelemetry Line Protocol

We recommend using the OpenTelemetry collector for ingesting the spans to Promscale. Use this configuration with the OTLP exporter and batch processor to help with retries for failed writes, and to batch the write requests to Promscale:

  1. exporters:
  2. logging:
  3. otlp:
  4. endpoint: "<PROMSCALE_HOST>:<gRPC_PORT>"
  5. tls:
  6. insecure: true
  7. sending_queue:
  8. queue_size: 1000000
  9. timeout: 10s
  10. processors:
  11. batch:
  12. send_batch_size: 4000
  13. send_batch_max_size: 4000
  14. timeout: 10s

Where:

  • <PROMSCALE_HOST>: hostname of Promscale
  • <gRPC_PORT>: gRPC port of Promscale. The default port is 9202.

Compute recommendations for the Promscale connector and TimescaleDB are:

Ingestion RateConnector CPUConnector MemoryDB CPUDB MemoryDB connections
10k spans/sec = ~2.5 MB/sec0.54 GB24 GB4
50k spans/sec = ~5 MB/sec28 MB48 GB8
100k spans/sec = ~10 MB/sec416 GB816 GB16
200k spans/sec = ~20 MB/sec816 GB1616 GB32

Disk recommendations for TimescaleDB are:

The default chunk interval is 1h

Ingest rateRetentionDisk size per dayUncompressed bufferTotal disk sizeWAL size
10k spans/sec = ~2.5 MB/sec30 days~30 GB~35 GB~935 GB20 GB
50k spans/sec = ~5 MB/sec30 days~60 GB~175 GB~2 TB-
100k spans/sec= ~10 MB/sec30 days~150 GB~350 GB~5 TB-
200k spans/sec= ~20 MB/sec30 days~300 GB~700 GB~10 TB-