Re: Vacuum full connection exhaustion

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum full connection exhaustion
Date: 2024-08-09 04:17:51
Message-ID: 71219E8D-AD7F-4520-BD6F-975DA55D9DF4@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Aug 8, 2024, at 21:15, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> "I see a lock, so let's cause another one!" That's crazy.

It's more "Oh, look, I need a connection to service this web request, but my pool is empty, so I'll just fire up a new connection to the server," lather, rinse, repeat. Pretty common these days, sadly.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-08-09 04:20:04 Re: Getting specific partition from the partition name
Previous Message Ron Johnson 2024-08-09 04:15:33 Re: Vacuum full connection exhaustion