Skip to main content
S
sarathi1-Visitor
1-Visitor
February 6, 2019
Solved

If i execute any query service it will take long time respond.

  • February 6, 2019
  • 1 reply
  • 2695 views

If i execute any query service it will take long to respond , Thingworx Server is Configured with postgresql,   So i need to check postgresql health checkup and do i need to run any database Maintenance service separatly?

 

    Best answer by mnarang

    Hi ,

     

    I think you also opened a support case with the same issue .Still if you have huge data in data tables and frequent update/delete operations on the data table .There might be dead tuples occurred in the schema side .That will cause data fetch very slow from the DB .Kindly see this doc for more understanding and to run VACUUM process on the table .

    https://www.ptc.com/en/support/article?n=CS261063

     

    Hope it helps 

     

    Thanks ,

    Mukul Narang 

    1 reply

    M
    mnarang5-Regular Member
    5-Regular Member
    February 6, 2019

    It seems you have postgresql connected as external DB to ThingWorx .And there might be many reasons for long run as the Schema will be prepared by you manually .So if there are select on a large data ,index should be there .Or even there is frequent update/delete on the table ,you should run VACUUM (FULL/VERBOSE/ANALYZE) to check and removal for the possibility of dead tuples .

     

    I hope my understand is correct according to your question ,if the issue is something else then elaborate the use case to understand it better .

     

    Thanks ,

    Mukul Narang 

    S
    sarathi1-VisitorAuthor
    1-Visitor
    February 6, 2019

    Hi @mnarang , Thank for your information but Postgressql is defalut thingworx persistance provider, am using default thingworx default schema

    M
    mnarang5-Regular Member
    5-Regular Member
    February 6, 2019

    So that means you are querying ThingWorx schema in PostgreSql as persistence provider .Can you please elaborate ,what kind of query you are firing ? What is the use case here ?

    I thought you are trying a SQL query service on a DB thing (Connected to external Postgresql DB) .  

    Terms & ConditionsCookie settingsAccessibility statement