Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41851=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VemEH-0002Fq-87
 for pgsql-admin@arkaria.postgresql.org; Fri, 08 Nov 2013 13:36:05 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41851=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VemEG-000207-OX
 for pgsql-admin@arkaria.postgresql.org; Fri, 08 Nov 2013 13:36:04 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rvoinea@gmail.com>) id 1Vem4J-0008Au-4s
 for pgsql-admin@postgresql.org; Fri, 08 Nov 2013 13:25:47 +0000
Received: from mail-ea0-x236.google.com ([2a00:1450:4013:c01::236])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rvoinea@gmail.com>) id 1Vem4F-0005VZ-Vo
 for pgsql-admin@postgresql.org; Fri, 08 Nov 2013 13:25:46 +0000
Received: by mail-ea0-f182.google.com with SMTP id o10so1116870eaj.13
 for <pgsql-admin@postgresql.org>; Fri, 08 Nov 2013 05:25:42 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=from:to:cc:subject:date:message-id:user-agent:in-reply-to
 :references:mime-version:content-transfer-encoding:content-type;
 bh=cJptd1JyuOzlDPjazeJkOxOxbpIvrbdqw6jA1VLVcto=;
 b=BmGVRmp3x6HRt4iqRoYYFCsdcw/IT3rLuC6TBbEzvh3LBjvqi/up0CKgowq0VPRc0Y
 k1wb31F2af9VxUxivZZEFLuE7qADNxvb5kRa4/RRNshgrYrdNxb8xF5VMqC003JBnUcK
 fStIm3scVy+MlHO5WjtOYlT47+MA1NTLzE0M0udnhCf5eWAoiuCuDDEgttn4YjlFiCyy
 XAR5xCjpCWtKJK+g5tCAiS4I57gqNQkYeFUWCAIx0ZlhAIXXdWG7/zeAp2cMVvFXgXo+
 va392UOGhjParr8C61X4wYiCuGguCj/uxVjkcHUURjM5YEAtkpANOeonf3b3HrWQtMC6
 lsIg==
X-Received: by 10.14.107.68 with SMTP id n44mr16950794eeg.26.1383917141957;
 Fri, 08 Nov 2013 05:25:41 -0800 (PST)
Received: from shu.localnet ([89.38.174.207])
 by mx.google.com with ESMTPSA id e13sm22820271eeu.4.2013.11.08.05.25.41
 for <multiple recipients>
 (version=TLSv1.1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Fri, 08 Nov 2013 05:25:41 -0800 (PST)
From: Robert Voinea <rvoinea@gmail.com>
To: bricklen <bricklen@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Occasional spike in query response time (jumps from 200ms to 45
 seconds)
Date: Fri, 08 Nov 2013 15:25:40 +0200
Message-ID: <1609445.bRHEtEVPHv@shu>
User-Agent: KMail/4.11.1 (Linux/3.10.12-031012-generic; KDE/4.11.1; i686; ; )
In-Reply-To: 
 <CAGrpgQ-4Ozw8_7DF3sLMkqqnxNU+Wsqg6sZ4w20cZd0WAkyL1A@mail.gmail.com>
References: <16690513.cUljA3p6su@shu>
 <CAGrpgQ-4Ozw8_7DF3sLMkqqnxNU+Wsqg6sZ4w20cZd0WAkyL1A@mail.gmail.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="utf-8"
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi

On Thursday 07 November 2013 06:37:57 bricklen wrote:
> On Thu, Nov 7, 2013 at 2:44 AM, Robert Voinea <rvoinea@gmail.com> wrote:
> > Could you give me some hints on what to look for?
> > What might be causing this behavior?
> 
> Possibly checkpointing is the problem? Is "log_checkpoints" enabled in your
> postgresql.conf?  What is "checkpoint_completion_target" set to?

The parameters are commented out, so they are at their default values.

Thank you for replying.
I'll investigate this further to see if this is the problem.

-- 
Robert Voinea
Software Engineer
+4 0740 467 262

Don't take life too seriously. You'll never get out of it alive.
(Elbert Hubbard)




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin