Database log in - Mailing list pgsql-admin

From David G. Johnston
Subject Database log in
Date
Msg-id CAKFQuwZGywd1hUbvgq+4j9eCEZWtDYL7c4WFofy01ygOXtjYiw@mail.gmail.com
Whole thread Raw
In response to Database log in  ("Heckler, Kim M" <kim.heckler@nationwide.com>)
Responses Re: Database log in
List pgsql-admin
On Wednesday, January 24, 2024, Heckler, Kim M <kim.heckler@nationwide.com> wrote:

My questions are around what happens at log in time; what are the sequence of events?  Also, how much “stress” does log in have to the DBMS? 

A decent amount. 

 How many concurrent logins can the DBMS handle in a short time frame?  Can 40 sessions be initiated within 90 seconds?  60 seconds?

It depends.

Please, I would appreciate debugging suggestions.

Don’t? At this point you’ve probably hit the point where connection pools are the best way forward.  Especially since 8 is much less than 40.

David J.

pgsql-admin by date:

Previous
From: "Heckler, Kim M"
Date:
Subject: Database log in
Next
From: MichaelDBA
Date:
Subject: Re: Database log in