Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id EAB729FB30A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 28 Sep 2006 09:41:19 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 85128-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 28 Sep 2006 09:41:11 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.186])
	by postgresql.org (Postfix) with ESMTP id 071D79FB309
	for <pgsql-performance@postgresql.org>;
	Thu, 28 Sep 2006 09:41:10 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id p77so791870nfc
	for <pgsql-performance@postgresql.org>;
	Thu, 28 Sep 2006 05:41:09 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:from:to:references:subject:date:mime-version:content-type:content-transfer-encoding:x-priority:x-msmail-priority:x-mailer:x-mimeole;
	b=jtbgo6mvxvllexriASpk8q3C4hc103lBKeZc+HqiDbVeD4+XaLnSOEMhYSY6IrCpYpZBxeNm3TJ2tH3AZGOcUHVAuHyv2XX6DXOFfJr61H7flfOfUcv3El+BQx9bCuEwG066pyMplvRrcY3m3jlwSbM6uXIkzqiQ/SdQIgzJO0E=
Received: by 10.49.55.13 with SMTP id h13mr3655941nfk;
	Thu, 28 Sep 2006 05:41:09 -0700 (PDT)
Received: from maniek ( [81.219.252.2])
	by mx.gmail.com with ESMTP id p45sm5519929nfa.2006.09.28.05.41.08;
	Thu, 28 Sep 2006 05:41:08 -0700 (PDT)
Message-ID: <1c9501c6e2fb$91e30200$0c67a8c0@maniek>
From: "Marcin Mank" <marcin.mank@gmail.com>
To: "Matthew Schumacher" <matt.s@aptalaska.net>,
	<pgsql-performance@postgresql.org>
References: <451AC4E2.90106@aptalaska.net>
Subject: Re: Problems with inconsistant query performance.
Date: Thu, 28 Sep 2006 14:42:32 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200609/382
X-Sequence-Number: 21068

> So the question is why on a relatively simple proc and I getting a query
> performance delta between 3549ms and 7ms?

What version of PG is it?

I had such problems in a pseudo-realtime app I use here with Postgres, and
they went away when I moved to 8.1 (from 7.4). I guess it is better shared
buffer management code (don`t You see a
big_query_searching_through_half_the_db just before You get this slow
insert? ) .

Greetings
Marcin