From: | bweishoff(at)charter(dot)net |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgres timeouts? |
Date: | 2013-08-14 12:36:57 |
Message-ID: | 62d1445f.21169b.1407cd437e8.Webtop.44@charter.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm having an interesting issue with PGSQL. It seems that I'm
experiencing timeouts at various times. The servers are not busy and
have plenty of resources. The databases are ~50GB in size, the systems
typically have 8-12GB physical RAM, and the connections are low (less
than 15 at any given time).
The issue I'm seeing is that randomly I'm getting these pauses, or
stalls, while trying to simply connect to the database server(s) from
connected clients using the psql command line client. I cannot tell if
the server is even getting the request for service as they don't seem to
show up in the logs at the time the event is occurring, so I'm thinking
it's maybe a client-side issue.
Is there a good general starting place for debugging these types of
issues ?
-B.
From | Date | Subject | |
---|---|---|---|
Next Message | coutinhoviola | 2013-08-14 12:50:51 | Re: Please help |
Previous Message | Ivan Radovanovic | 2013-08-14 12:17:26 | Getting list of supported types in Postgres |