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.
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