pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: DB Server slow down & hang during Peak hours of Usage
Date: Mon, 7 Aug 2023 10:08:28 -0500
Message-ID: <1a4d0a85-c037-a9a4-d550-a51fc5e556ff@gmail.com> (raw)
In-Reply-To: <CAKgGyB8R7Jynvw35vfFXLRw+dNOnwTTOyHndk1L7rUPn+JQaQQ@mail.gmail.com>
References: <CAKgGyB8R7Jynvw35vfFXLRw+dNOnwTTOyHndk1L7rUPn+JQaQQ@mail.gmail.com>

On 8/7/23 08:41, KK CHN wrote:
> List ,
>
> *Description:*
>
> Maintaining a DB Server Postgres and with a lot of read writes to this 
> Server( virtual machine running on  ESXi 7 with CentOS 7) .
>
> ( I am not sure how to get the read / write counts or required IOPS or any 
> other parameters for you. If  you point our  I can execute those commands 
> and get the data. )
>
> Peak hours  say 19:00 Hrs to 21:00 hrs it hangs ( The application is an 
> Emergency call response system  writing many  Emergency Response vehicles 
> locations coordinates to the DB every 30 Seconds and every emergency call 
> metadata (username, phone number, location info and address of the caller 
> to the DB for each call)
>
> During these hours  the system hangs and the  Application ( which shows 
> the location of the vehicles on a  GIS map hangs ) and the CAD machines 
> which connects to the system hangs as those machines can't  connect to the 
> DB and get data for displaying the caller information to the call taking 
> persons working on them. )

Have you looked at the postgresql log file?

Have you looked in the *application* error log?

>
> *Issue : *
> How to trace out what makes this DB  hangs and make it slow  and how to 
> fix it..
>
> *Resource poured on the system :*
> *
> *
> *64 vCPUs  allocate ( Out of a host machine comprised of 2 processor slots 
> of 20 cores each with Hyper Threading, intel xeon 2nd Gen, CPU usage show 
> 50 % in vCentre Console), and RAM 64 GB allocated ( buy usage always 
> showing around 33 GB only ) *
> *
> *

What else happens on the ESXi host between 19:00 and 21:00?

> *Query :*
> *
> *
> How to rectify the issues that makes the DB server underperforming and 
> find a permanent fix for this slow down issue*. *
> *
> *
> *Attached the  Postgres.conf file here for reference .*
> *
> *
> *Any more information required I can share for analysis to fix the issue. *
> *
> *
>
> *Krishane *

-- 
Born in Arizona, moved to Babylonia.

view thread (5+ messages)  latest in thread

Message-ID: <1a4d0a85-c037-a9a4-d550-a51fc5e556ff@gmail.com>
Permalink:  ../1a4d0a85-c037-a9a4-d550-a51fc5e556ff@gmail.com/
Also on:    postgresql.org/message-id/1a4d0a85-c037-a9a4-d550-a51fc5e556ff@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: ronljohnsonjr@gmail.com
  Subject: Re: DB Server slow down & hang during Peak hours of Usage
  In-Reply-To: <1a4d0a85-c037-a9a4-d550-a51fc5e556ff@gmail.com>
  References: <CAKgGyB8R7Jynvw35vfFXLRw+dNOnwTTOyHndk1L7rUPn+JQaQQ@mail.gmail.com> <1a4d0a85-c037-a9a4-d550-a51fc5e556ff@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox