On 22 June 2023 07:09:26 CEST, KK CHN <kkchn.in@xxxxxxxxx> wrote: >*Description of System: * >1. We are running a Postgres Server (version 12, on CentOS 6) for an >emergency call attending and vehicle tracking system fitted with mobile >devices for vehicles with navigation apps for emergency service. > >2. vehicles every 30 Seconds sending location coordinates( Lat /Long ) and >getting stored into the DB server at the emergency call center cum control >room. > >*Issue: * >We are facing an issue of the database hanging and becoming unresponsive >for >applications running which try to connect to the DB. > >*Question: * >How to optimize and fine tune this database performance issue ? Definitely >pouring the resources like the above is not a solution. > >What to check the root cause and find for the performance bottle neck >reasons ? > Have you THP disabled? Andreas
