Re: Create Index Performance Issue

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Create Index Performance Issue
Date: 2008-06-04 09:58:29
Message-ID: 20080604095829.GB23526@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message rotellaro 2008-06-04 11:07:45 Corrupted WAL during recovery from archived log
Previous Message Rudolf van der Leeden 2008-06-04 09:43:24 Create Index Performance Issue