Postgres Pro
Downloads
Home   >   mailing lists

Re: Occasional timeouts on TRUNCATE and simple INSERTs - Mailing list pgsql-performance

From Osborn, Jeff
Subject Re: Occasional timeouts on TRUNCATE and simple INSERTs
Date
Msg-id CD2B5B7A-8844-445C-8A5C-A2EB35EAD58C@akamai.com
Whole thread Raw
In response to Re: Occasional timeouts on TRUNCATE and simple INSERTs  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Occasional timeouts on TRUNCATE and simple INSERTs  ("Osborn, Jeff" <jeosborn@akamai.com>)
List pgsql-performance
Tree view 
Yeah I've been running a cron pulling relevant info from pg_stat_activity.  Haven't seen anything yet.  Currently
lookinginto the pg_dump situation. 

--Jeff O

On Dec 11, 2012, at 5:16 PM, Merlin Moncure wrote:

> On Tue, Dec 11, 2012 at 3:38 PM, Sergey Konoplev <gray.ru@gmail.com> wrote:
>
> Yeah: absolute first thing to check is if your statements are being
> blocked -- you can get that via pg_stat_activity from another session.
> It's a completely different beast if that's the case.
>
> merlin
Attachment

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Occasional timeouts on TRUNCATE and simple INSERTs
Next
From: Niels Kristian Schjødt
Date:
Subject: Re: Do I have a hardware or a software problem?