Re: Connection with PG Admin terribly slow and constant disconnects

[Rob Stradling]

Hi Jordan.

This happens when users are hammering the replica DBs that power crt.sh:5432.  pg_bouncer queues each pending connection until one of the limited number of connection slots becomes available.

We limit the number of concurrent connections from each unique IP address, and our Ops team will from time to time block any IPs that they consider to be "abusing" the service.  Nonetheless, the service continues to be a victim of its own success.

---

From: cr...@googlegroups.com <cr...@googlegroups.com> on behalf of Jordan Trulen <j...@firmguardian.com>
Sent: 04 June 2024 17:41
To: crt.sh <cr...@googlegroups.com>
Subject: Connection with PG Admin terribly slow and constant disconnects

 

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Greetings!

I'm trying to dig into some certificates issued under a similar name to my companies, and I'm using PG Admin to do it. My problem is that my connection to the database seems incredibly slow, to the point that just connecting can take upwards of 30 minutes with frequent timeouts. I can connect to other postgres databases without any issue, but this one seems terribly slow. Whenever I do manage to get connected and execute a basic query, it's not uncommon to get disconnected 5-10 times, leading to me having to execute the query again and again.

Is there any way to resolve this issue? It's nearly unusable for me at this time.

--
You received this message because you are subscribed to the Google Groups "crt.sh" group.
To unsubscribe from this group and stop receiving emails from it, send an email to crtsh+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/crtsh/96e120a7-c212-496b-b883-7cde1d4f478cn%40googlegroups.com.