Postgres Pro
Downloads
Home   >   mailing lists

Re: Extremely slow to establish connection when user has a high number of roles - Mailing list pgsql-performance

From Michal Charemza
Subject Re: Extremely slow to establish connection when user has a high number of roles
Date
Msg-id CAJe2WWgXupxEr8WgXK7uBT6rJ2aey==q9EbnSzs6wYfv69+k1Q@mail.gmail.com
Whole thread Raw
In response to Re: Extremely slow to establish connection when user has a high number of roles  (Frits Hoogland <frits.hoogland@gmail.com>)
List pgsql-performance
Tree view
Frits Hoogland <frits.hoogland@gmail.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.

pgsql-performance by date:

Previous
From: Frits Hoogland
Date:
Subject: Re: Extremely slow to establish connection when user has a high number of roles
Next
From: Tom Lane
Date:
Subject: Re: Extremely slow to establish connection when user has a high number of roles