Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VeN5O-0007Eb-NI for pgsql-admin@arkaria.postgresql.org; Thu, 07 Nov 2013 10:45:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VeN5O-00085V-5k for pgsql-admin@arkaria.postgresql.org; Thu, 07 Nov 2013 10:45:14 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VeN5L-00084A-T3 for pgsql-admin@postgresql.org; Thu, 07 Nov 2013 10:45:12 +0000 Received: from mail-ee0-x235.google.com ([2a00:1450:4013:c00::235]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VeN5H-0001TJ-2v for pgsql-admin@postgresql.org; Thu, 07 Nov 2013 10:45:10 +0000 Received: by mail-ee0-f53.google.com with SMTP id e51so196401eek.26 for ; Thu, 07 Nov 2013 02:45:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:to:subject:date:message-id:user-agent:mime-version :content-transfer-encoding:content-type; bh=nmO6vevB503GbljEIMXEYFRLg+Ofw7Grt+CqECvC0RI=; b=gjld7GMmcWBVTbS614JvvOSswB2dgoi1XZZ/pLmjxDsg+OeLGWZLDF16ln/zSSuXIE w6tn7MPts2wDjdJXgLDm2B/eWuuL5FAU0cT0XKrWKvTc0RPsIOaJXg+yvFQBSZEndJt+ 2X92rrhajN+Kpaw2jVM3Fk4aImbndFOREd+qIYShv02Lx+D4M1O2ZusoLT9jqO2fOHno bY+jKd+wLsX/lPAvANquMTu9IEwlKCoFRrM6rasJBUzun/Dn5aRcPxpg+Ijcj5y6noZj e244hXX65P4JnqLaRjHodIuLzoLNwEh/NHDCVT8+eNV+FcVZA3boL0t+9OUoNTV3k0JU NvVw== X-Received: by 10.15.24.68 with SMTP id i44mr975711eeu.87.1383821105088; Thu, 07 Nov 2013 02:45:05 -0800 (PST) Received: from shu.localnet ([89.38.174.207]) by mx.google.com with ESMTPSA id w6sm7544924eeo.12.2013.11.07.02.45.01 for (version=TLSv1.1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Thu, 07 Nov 2013 02:45:03 -0800 (PST) From: Robert Voinea To: pgsql-admin@postgresql.org Subject: Occasional spike in query response time (jumps from 200ms to 45 seconds) Date: Thu, 07 Nov 2013 12:44:59 +0200 Message-ID: <16690513.cUljA3p6su@shu> User-Agent: KMail/4.11.1 (Linux/3.10.12-031012-generic; KDE/4.11.1; i686; ; ) MIME-Version: 1.0 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="utf-8" X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi list