pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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. 




view thread (6+ messages)

Message-ID: <42651E7B.7080702@ca.afilias.info>
Permalink:  ../42651E7B.7080702@ca.afilias.info/
Also on:    postgresql.org/message-id/42651E7B.7080702@ca.afilias.info

 · 

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: 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