From: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com> |
---|---|
To: | Barth Weishoff <bweishoff(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Debugging Postgres? |
Date: | 2013-08-15 02:14:20 |
Message-ID: | CAFS1N4gGWb9gyB36x1ugh21G3nE7HxGqxZnNC2hs1Lu=0QmmJA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Having a look at the PostgreSQL log may help.
http://stackoverflow.com/questions/722221/how-to-log-postgres-sql-queries
You could also try logging in via psql on the database host itself, to
ensure it is not a network issue.
Regards,
Jayadevan
On Wed, Aug 14, 2013 at 2:21 AM, Barth Weishoff <bweishoff(at)gmail(dot)com> wrote:
> Hello
>
> 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 | Michael Paquier | 2013-08-15 03:23:31 | Re: Getting list of supported types in Postgres |
Previous Message | Robert James | 2013-08-15 00:15:43 | Re: What type of index do I need for this JOIN? |