X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2262A52998
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Jul 2005 13:27:32 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 70648-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 19 Jul 2005 16:27:25 +0000 (GMT)
Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10])
	by svr1.postgresql.org (Postfix) with ESMTP id 4208452863
	for <pgsql-performance@postgresql.org>;
	Tue, 19 Jul 2005 13:27:23 -0300 (ADT)
Received: (qmail 13247 invoked from network); 19 Jul 2005 18:27:57 +0200
Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4)
	by boutiquenumerique.com with SMTP; 19 Jul 2005 18:27:57 +0200
To: "Tom Lane" <tgl@sss.pgh.pa.us>,
 "Christopher Petrilli" <petrilli@gmail.com>
Cc: "Vivek Khera" <vivek@khera.org>, pgsql-performance@postgresql.org
Subject: Re: Impact of checkpoint_segments under continual load conditions 
References: <59d991c4050717100874c08a86@mail.gmail.com>
	<A50B8A1F-71A1-4F63-A5F4-1AA58F89557D@khera.org>
	<59d991c405071811457ccdd3f1@mail.gmail.com>
	<16394.1121715156@sss.pgh.pa.us>
	<59d991c405071812342e290f57@mail.gmail.com>
	<16794.1121718743@sss.pgh.pa.us>
	<59d991c405071907482bb0689b@mail.gmail.com>
	<op.st52tvunth1vuj@localhost>
	<59d991c4050719084460b376f1@mail.gmail.com>
	<4541.1121788647@sss.pgh.pa.us>
Message-ID: <op.st55bvlgth1vuj@localhost>
From: PFC <lists@boutiquenumerique.com>
Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?=
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Date: Tue, 19 Jul 2005 18:27:21 +0200
In-Reply-To: <4541.1121788647@sss.pgh.pa.us>
User-Agent: Opera M2/8.0 (Linux, build 1095)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200507/286
X-Sequence-Number: 13527



> total.  If the insertion pattern is sufficiently random that the entire
> index ranges are "hot" then you might not have enough RAM.

	Try doing the test dropping some of your indexes and see if it moves the  
number of iterations after which it becomes slow.