pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: Nurlan Mukhanov (AL/EKZ) <Nurlan.Mukhanov@ericsson.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql works too slow
Date: Tue, 19 Apr 2005 15:46:33 +0100
Message-ID: <1113921994.16721.2162.camel@localhost.localdomain> (raw)
In-Reply-To: <70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se>
References: <70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se>

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




view thread (6+ messages)  latest in thread

Message-ID: <1113921994.16721.2162.camel@localhost.localdomain>
Permalink:  ../1113921994.16721.2162.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1113921994.16721.2162.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: simon@2ndquadrant.com, Nurlan.Mukhanov@ericsson.com
  Subject: Re: Postgresql works too slow
  In-Reply-To: <1113921994.16721.2162.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox