| From: | "Heckler, Kim M" <kim(dot)heckler(at)nationwide(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Database log in |
| Date: | 2024-01-24 21:22:28 |
| Message-ID: | SA1PR07MB8484F96961B8B73832FB3F4B867B2@SA1PR07MB8484.namprd07.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
All,
I am experiencing intermitently, slow, log in times. My connection scenario:
1. Kube pod is hosted in Ohio, in AWS account A.
2. Using psql, a log in attempt is initiated from the pod.
3. RDS Postgres Instance is hosted in Ohio, in account B. host has 8 vCPU and 32 GB of RAM. CPU and IO are not a bottle neck.
4. We experience intermittent log in slowness.
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? How many concurrent logins can the DBMS handle in a short time frame? Can 40 sessions be initiated within 90 seconds? 60 seconds?
Please, I would appreciate debugging suggestions.
Thank you in advance, Kim.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-01-24 21:34:44 | Database log in |
| Previous Message | kaido vaikla | 2024-01-24 17:04:33 | Re: pg_dumpall and owner of the extension |