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 C211A3A4786 for ; Tue, 2 Nov 2004 01:36:25 +0000 (GMT) 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 40801-04 for ; Tue, 2 Nov 2004 01:36:12 +0000 (GMT) Received: from sue.samurai.com (sue.samurai.com [205.207.28.74]) by svr1.postgresql.org (Postfix) with ESMTP id 0FA5D3A4782 for ; Tue, 2 Nov 2004 01:36:13 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by sue.samurai.com (Postfix) with ESMTP id B2568197FB; Mon, 1 Nov 2004 20:36:13 -0500 (EST) Received: from sue.samurai.com ([127.0.0.1]) by localhost (sue.samurai.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 09240-01-9; Mon, 1 Nov 2004 20:36:10 -0500 (EST) Received: from [61.88.101.19] (unknown [61.88.101.19]) by sue.samurai.com (Postfix) with ESMTP id 71FCD197A7; Mon, 1 Nov 2004 20:36:09 -0500 (EST) Subject: Re: Speeding up Gist Index creations From: Neil Conway To: Josh Berkus Cc: pgsql-performance@postgresql.org, mallah@trade-india.com In-Reply-To: <200410311601.15408.josh@agliodbs.com> References: <46946.192.168.0.11.1099256590.squirrel@office1.trade-india.com> <200410311601.15408.josh@agliodbs.com> Content-Type: text/plain Message-Id: <1099359354.17405.150.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 02 Nov 2004 12:35:55 +1100 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/12 X-Sequence-Number: 8966 On Mon, 2004-11-01 at 11:01, Josh Berkus wrote: > > Gist indexes take a long time to create as compared > > to normal indexes is there any way to speed them up ? > > > > (for example by modifying sort_mem or something temporarily ) > > More sort_mem will indeed help. How so? sort_mem improves index creation for B+-tree because we implement bulk loading; there is no implementation of bulk loading for GiST, so I don't see how sort_mem will help. -Neil