Re: Occasional timeouts on TRUNCATE and simple INSERTs

From: "Osborn, Jeff" <jeosborn(at)akamai(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Occasional timeouts on TRUNCATE and simple INSERTs
Date: 2012-12-11 22:34:16
Message-ID: CD2B5B7A-8844-445C-8A5C-A2EB35EAD58C@akamai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Yeah I've been running a cron pulling relevant info from pg_stat_activity. Haven't seen anything yet. Currently looking into 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(dot)ru(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Niels Kristian Schjødt 2012-12-11 22:41:37 Re: Do I have a hardware or a software problem?
Previous Message Merlin Moncure 2012-12-11 22:16:43 Re: Occasional timeouts on TRUNCATE and simple INSERTs