Re: Create Index Performance Issue - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: Create Index Performance Issue
Date
Msg-id 20080604095829.GB23526@easy2.in-chemnitz.de
Whole thread Raw
In response to Create Index Performance Issue  (Rudolf van der Leeden <vanderleeden@logicunited.com>)
List 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

pgsql-admin by date:

Previous
From: Rudolf van der Leeden
Date:
Subject: Create Index Performance Issue
Next
From: "rotellaro"
Date:
Subject: Corrupted WAL during recovery from archived log