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:54:59 -0500
Message-ID: <d99d24d9-e29e-46e8-41af-dacef4bf8bc6@sqlexec.com> (raw)
In-Reply-To: <CAK-MWwSDSKoL+8mwYyZA_pfbe6URigtwDwFXd2BY8vEJHS4GdQ@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>
	<49cec5cf-efd5-8be1-cebb-43a6594e07d3@sqlexec.com>
	<CAK-MWwSDSKoL+8mwYyZA_pfbe6URigtwDwFXd2BY8vEJHS4GdQ@mail.gmail.com>

You said it's a dedicated server, but pgbouncer is running locally, 
right?  PGBouncer has a small footprint, but is the CPU high for it?

Maxim Boguk wrote on 1/1/2023 11:51 AM:
>
>
> On Sun, Jan 1, 2023 at 6:43 PM MichaelDBA <MichaelDBA@sqlexec.com 
> <mailto:MichaelDBA@sqlexec.com>> wrote:
>
>     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?
>
>
> LA 10-15 all time, servers are really overprovisioned (2-3x by 
> available CPU resources) because an application is quite sensitive to 
> the database latency.
> And during these latency spikes - EXECUTE work without any issues 
> (e.g. only PARSE/BIND suck).
>
>
> -- 
> Maxim Boguk
> Senior Postgresql DBA
> https://dataegret.com/
>
> Phone UA: +380 99 143 0000
> Phone AU: +61  45 218 5678
>


Regards,

Michael Vitale

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

703-600-9343

Attachments:

  [image/jpeg] pgadvanced3.jpg (20.6K, ../d99d24d9-e29e-46e8-41af-dacef4bf8bc6@sqlexec.com/3-pgadvanced3.jpg)
  download | view image

view thread (13+ messages)  latest in thread

Message-ID: <d99d24d9-e29e-46e8-41af-dacef4bf8bc6@sqlexec.com>
Permalink:  ../d99d24d9-e29e-46e8-41af-dacef4bf8bc6@sqlexec.com/
Also on:    postgresql.org/message-id/d99d24d9-e29e-46e8-41af-dacef4bf8bc6@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: <d99d24d9-e29e-46e8-41af-dacef4bf8bc6@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