Re: Postgresql works too slow - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Postgresql works too slow
Date
Msg-id 1113921994.16721.2162.camel@localhost.localdomain
Whole thread Raw
In response to Postgresql works too slow  ("Nurlan Mukhanov (AL/EKZ)" <Nurlan.Mukhanov@ericsson.com>)
Responses Re: Postgresql works too slow  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-performance
On Mon, 2005-04-18 at 08:50 +0400, Nurlan Mukhanov (AL/EKZ) wrote:
> I'm trying to restore my database from dump in several parrallel processes, but restore process works too slow.
> Number of rows about 100 000 000,
> RAM: 8192M
> CPU: Ultra Sparc 3
> Number of CPU: 4
> OS: SunOS sun 5.8
> RDBMS: PostgreSQL 8.0

> How to encrease postgresql speed? Why postgres took only 5.0% of CPU time?

When you say restore...what are you actually doing?
An archive recovery?
A reload?
A file-level restore of database?

Best Regards, Simon Riggs


pgsql-performance by date:

Previous
From: "Mohan, Ross"
Date:
Subject: Re: How to improve db performance with $7K?
Next
From: Brad Nicholson
Date:
Subject: Re: Postgresql works too slow