Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I have a few applications which have heavy queries to read and write the stream data also complex services/mashups as well. Now, We have DB and TWX foundation both in the same EC2 instance.
To reduce the load I would like to move my entire DB to AWS RDS PSQL. It is good to proceed with this approach or should I create a separate EC2 instance to host my Postgres?
Also, We have manufacturing apps in the instance it has custom tables in the main DB.
Changing the stream data to another DB is not helping I tried to use an external DB as ThingworxPersistenceProvider, it is reducing the load but still, due to a load of services and application model postgres service consumes high cpu utilization.
Solved! Go to Solution.
I have received information from platform support team like AWS RDS is not officially supported by the support matrix of thingworx.
AWS RDS should be fine, Just make sure you have a compatible version of Postgres provided.
I have received information from platform support team like AWS RDS is not officially supported by the support matrix of thingworx.
That is unfortunate, I do know it works (I've done some projects with AWS RDS) but if it is not officially supported, it would make it hard to get official technical support from PTC.