Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 480AE2E00EF for ; Wed, 4 Jun 2008 06:58:51 -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 58819-04 for ; Wed, 4 Jun 2008 06:58:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by developer.postgresql.org (Postfix) with ESMTP id 4E4642E00C3 for ; Wed, 4 Jun 2008 06:58:31 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 4362F47001D for ; Wed, 4 Jun 2008 11:58:29 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id oaDx6-nZu0OV for ; Wed, 4 Jun 2008 11:58:29 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 31839470008; Wed, 4 Jun 2008 11:58:29 +0200 (CEST) Date: Wed, 4 Jun 2008 11:58:29 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Create Index Performance Issue Message-ID: <20080604095829.GB23526@easy2.in-chemnitz.de> References: <7EB14E30-23D1-49FF-AB57-E53A8CD3AE72@logicunited.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7EB14E30-23D1-49FF-AB57-E53A8CD3AE72@logicunited.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/24 X-Sequence-Number: 29362 On Wed, Jun 04, 2008 at 11:43:24AM +0200, Rudolf van der Leeden wrote: > I'm currently testing a 25G Postgres 8.3.0 database on Apple Xserve/ > Intel with Mac OSX 10.5 (Leopard). > > There are two identical machines with identical configurations (hw > and sw). > Running a pg_restore of a binary backup file (3.8 GB) on both > machines gives the following results: > > Machine A : 90 minutes > Machine B: 60 minutes Maybe there are some background processes running? Tino. -- "What we resist, persists." (Zen saying) www.craniosacralzentrum.de www.forteego.de