From: | Adam Sjøgren <asjo(at)koldfront(dot)dk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Subject: | Re: Database logins taking longer and longer, showing up as "authentication" in ps(1) |
Date: | 2020-08-18 14:47:26 |
Message-ID: | 877dtwc8ox.fsf@tullinup.koldfront.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Laurenz writes:
> On Tue, 2020-08-18 at 14:53 +0200, Adam Sjøgren wrote:
>>
>> We have 60 processes (workers) running on different machines accessing
>> the database, that all grab jobs from a queue and update rows in a table
>> after doing some calculations (which vary in time from <1s to perhaps a
>> minute, many of them fast).
>>
>> Sometimes new database logins slow down, from usually taking <0.05s to
>> taking minutes. This is for psql as a normal user using Kerberos, for
>> psql as the postgres superuser, for the web-application logging into the
>> database, for everything.
>
> I would suspect that the problem is with the authentication method.
Interesting, how are you suspecting the interaction to be playing out?
> How is authenticatoin configured?
Primarily using gss (for the web-application, delegated credentials),
md5 (system users), and a few trust (for legacy access).
> I'd "strace" a connection that is hanging in "authenticating" and
> see what the process does.
I did that one of the previous times I have seen this problem, and saw
stuff like this:
2020-06-10 11:22:14 strace: Process 101559 attached
2020-06-10 11:22:14 futex(0x7f46df29e138, FUTEX_WAIT_BITSET|FUTEX_CLOCK_REALTIME, 0, NULL, ffffffff) = 0
...
2020-06-10 11:24:09 futex(0x7f46df29e138, FUTEX_WAIT_BITSET|FUTEX_CLOCK_REALTIME, 0, NULL, ffffffff) = 0
2020-06-10 11:24:09 futex(0x7f46df2a2e38, FUTEX_WAKE, 1) = 1
2020-06-10 11:24:09 brk(0x55c197084000) = 0x55c197084000
2020-06-10 11:24:09 brk(0x55c1970b0000) = 0x55c1970b0000
2020-06-10 11:24:09 open("global/pg_filenode.map", O_RDONLY) = 6
(where the elided part is futex() calls).
The slow login is regardless of whether I login with Kerberos or as the
postgres superuser with psql.
Best regards,
Adam
--
"Sometimes I feel like going home, walking in the Adam Sjøgren
boardroom asjo(at)koldfront(dot)dk
Sometimes I feel like I wanna go, walk into the
ballroom"
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-08-18 14:54:09 | Re: Database logins taking longer and longer, showing up as "authentication" in ps(1) |
Previous Message | Stephen Frost | 2020-08-18 14:33:51 | Re: Database logins taking longer and longer, showing up as "authentication" in ps(1) |