Re: Extremely slow to establish connection when user has a high number of roles

From: Michal Charemza <michal(at)charemza(dot)name>
To: Frits Hoogland <frits(dot)hoogland(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Extremely slow to establish connection when user has a high number of roles
Date: 2024-04-20 15:34:12
Message-ID: CAJe2WWgXupxEr8WgXK7uBT6rJ2aey==q9EbnSzs6wYfv69+k1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Frits Hoogland <frits(dot)hoogland(at)gmail(dot)com> writes:
> Michael, can you validate if this is consistently happening for the first
connection after database cluster startup?

Hmmm... it'll be tricky and need some planning. It might even be impossible
since this is on AWS Aurora, and I think AWS connects in regularly as part
of a heartbeat check(?)

But: do you mean any connection, or just a user that hasn't connected yet
after the restart? A user that hasn't connected yet would be much easier.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2024-04-20 15:52:47 Re: Extremely slow to establish connection when user has a high number of roles
Previous Message Frits Hoogland 2024-04-20 15:24:02 Re: Extremely slow to establish connection when user has a high number of roles