pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Maxim Boguk <maxim.boguk@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
Date: Sun, 1 Jan 2023 11:43:10 -0500
Message-ID: <49cec5cf-efd5-8be1-cebb-43a6594e07d3@sqlexec.com> (raw)
In-Reply-To: <CAK-MWwRsAS3fPNA5o674hOVghiRGJYx23mEVBccwmjVHk6umbQ@mail.gmail.com>
References: <CAK-MWwSfx7SmUQ=_rB4q61sE8uP6LqH-1wM0DSYyBadjBe9BDw@mail.gmail.com>
	<20221231143203.GK1153@telsasoft.com>
	<CAK-MWwTRVNoDnjeKh-03cpubS9D1hhY-UofwYQChtLM2Y1EwWg@mail.gmail.com>
	<2f7a8841-71c7-03e7-1bd5-2b1f95d24c16@sqlexec.com>
	<CAK-MWwRsAS3fPNA5o674hOVghiRGJYx23mEVBccwmjVHk6umbQ@mail.gmail.com>

Hi Maxim,

10-20 active, concurrent connections is way below any CPU load problem 
you should have with 48 available vCPUs.
You never explicitly said what the load is, so what is it in the context 
of the 1,5,15?

Maxim Boguk wrote on 1/1/2023 11:30 AM:
> 1)usual load (e.g. no anomalies)
> 10-20 concurrent query runs (e.g. issues isn't related to the load 
> spike or similar anomalies)
> additionally 5-10 short idle in transaction (usual amount too)
> total around 300 active connections to the database (after local 
> pgbouncer in transaction mode)


Regards,

Michael Vitale

Michaeldba@sqlexec.com <mailto:michaelvitale@sqlexec.com>

703-600-9343

Attachments:

  [image/jpeg] pgadvanced3.jpg (20.6K, ../49cec5cf-efd5-8be1-cebb-43a6594e07d3@sqlexec.com/3-pgadvanced3.jpg)
  download | view image

view thread (13+ messages)  latest in thread

Message-ID: <49cec5cf-efd5-8be1-cebb-43a6594e07d3@sqlexec.com>
Permalink:  ../49cec5cf-efd5-8be1-cebb-43a6594e07d3@sqlexec.com/
Also on:    postgresql.org/message-id/49cec5cf-efd5-8be1-cebb-43a6594e07d3@sqlexec.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: MichaelDBA@sqlexec.com, maxim.boguk@gmail.com, pryzby@telsasoft.com, pgsql-performance@lists.postgresql.org
  Subject: Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits)
  In-Reply-To: <49cec5cf-efd5-8be1-cebb-43a6594e07d3@sqlexec.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