Re: Postgresql works too slow

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