Max Measurements/Tables in Influx DB

[pshashipreetham]

Hi, 

I am migrating the Time-Series data from PostgreSQL to InfluxDB. In InfluxDB, there will be a separate measurement for each Thing in Thingworx, whereas in Postgres, all time-series data is stored in the public schema.value_stream table. 

Now I do have around 1400 Things, each thing represents a device, actually, as per the use case.

My Quick question is: is there a limit on the number of Measurements in a single InfluxDB?

Thingworx Version: 9.1

Thanks,

[TonyZhang]

Hi @pshashipreetham,

Reply by AI: InfluxDB does not impose a hard limit on the number of measurements per database, so having 1,400 measurements (one per Thing) is technically supported.

https://community.influxdata.com/t/is-there-any-max-limit-on-measurements-in-a-database/5860/2

Best,

[TonyZhang]

Hi @pshashipreetham,

Does my previous response to this post answer your question? For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.

In the event that this response did not answer your question, please post your current status so that we can continue to support.

Thanks for using the PTC Community!

Regards,