From: Brad Nicholson <bnichols@ca.afilias.info>
To: pgsql-performance@postgresql.org
Subject: Re: Postgresql works too slow
Date: Tue, 19 Apr 2005 11:06:35 -0400
Message-ID: <42651E7B.7080702@ca.afilias.info> (raw)
In-Reply-To: <1113921994.16721.2162.camel@localhost.localdomain>
References: <70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se>
<1113921994.16721.2162.camel@localhost.localdomain>
Simon Riggs wrote:
>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?
>
>
>
If you are doing a restore off a pg_dump, did you dump the data as
inserts? This takes a lot more time to restore.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
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: bnichols@ca.afilias.info
Subject: Re: Postgresql works too slow
In-Reply-To: <42651E7B.7080702@ca.afilias.info>
* 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