Niksa Jakovljevic

Thanks for sharing. This is concerning. It would be good if you can share the query plan by running the following query (e.g. using `psql`): `EXPLAIN (ANALYZE, BUFFERS) SELECT *...

@brasno Do you mind sharing Prometheus configuration, in particular the `remote_writer` part. Also sharing Prometheus and TimescaleDB/Postgres logs would be useful. Can you please be more specific and tell what...

@hvulin I'd recommend tweaking number of shards for `remote_write` configuration: ``` min_shards: 20 max_shards: 20 ``` We've seen performance degradation of Promscale due to Prometheus resharding. The rest of your...

Hi @maciejprz, In order to dig deeper into `no data` error I would recommend to run `prometheus-postgresql-adapter` with `--log.level=debug` and in the log file you will see SQL queries that...

@momania Not sure if that's the proper folder to store it? I guess the file should be named `pg_prometheus--0.0.1--0.2.1.sql` and should be stored where the rest of extensions sql scripts...

Hi @dmitriy-lukyanchikov The reason for getting errors seems to be invalid sample format. You should not escape `label_value` double quotes: so in your example `cluster=\"sf-prod-2\"` should instead be `cluster="sf-prod-2"`. Can...

You're right, the backslash is actually being inserted by the logger. I've tested your sample and it was inserted successfully which is weird. The error you are getting is coming...

For DB configuration I'd recommend going through TimescaleDB docs: https://docs.timescale.com/v1.0/getting-started/configuring (use `pg_tune` for PostgreSQL specific configs). There is no configuration needed for `pg_prometheus`. I am guessing that you are having...

Hmm ok. There are two different problems: 1. Did you see an improvement in write performances after tweaking Prometheus batch size? 2. I assume you are still encountering `pq: invalid...

I'd recommend using ZFS file system so data gets compressed around 4X. You will also notice performance improvements with ZFS. However, TimescaleDB can't match Prometheus disk usage b/c Prometheus is...