Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D33062E006F for ; Wed, 4 Jun 2008 11:45:43 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18283-05 for ; Wed, 4 Jun 2008 11:45:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by developer.postgresql.org (Postfix) with ESMTP id 233612E00E0 for ; Wed, 4 Jun 2008 11:45:38 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m54EjZki024531; Wed, 4 Jun 2008 10:45:35 -0400 (EDT) To: Rudolf van der Leeden cc: pgsql-admin@postgresql.org Subject: Re: Create Index Performance Issue In-reply-to: <7EB14E30-23D1-49FF-AB57-E53A8CD3AE72@logicunited.com> References: <7EB14E30-23D1-49FF-AB57-E53A8CD3AE72@logicunited.com> Comments: In-reply-to Rudolf van der Leeden message dated "Wed, 04 Jun 2008 11:43:24 +0200" Date: Wed, 04 Jun 2008 10:45:35 -0400 Message-ID: <24530.1212590735@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/28 X-Sequence-Number: 29366 Rudolf van der Leeden writes: > [ different times to build a varchar index on allegedly identical > installations ] Perhaps one is using C locale and the other is not? strcmp() vs strcoll() is a pretty big hit. In general it'd be worth dumping out the whole contents of pg_settings and diffing those two files to see if you missed any configuration differences. regards, tom lane