Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. 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.