pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hannu Krosing <hannu@tm.ee>
To: grupos@carvalhaes.net
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_restore taking 4 hours!
Date: Tue, 07 Dec 2004 13:08:38 +0200
Message-ID: <1102417717.3916.5.camel@fuji.krosing.net> (raw)
In-Reply-To: <41B364E8.3060406@carvalhaes.net>
References: <41ADA82A.7070405@carvalhaes.net>
	<200412011955.23543.ghodechhap@ghodechhap.net>
	<41B364E8.3060406@carvalhaes.net>

On P, 2004-12-05 at 21:43, Rodrigo Carvalhaes wrote:
> Hi !
> 
> Thanks for the lots of tips that I received on this matter.
> 
...
> There is something more that I can try to improve this performance?

check the speed of your ide drive. maybe tweak some params with
/sbin/hdparm . Sometimes the defaults result in 2MB/sec r/w speeds
(instead on(30-70 MB/sec)

------------
Hannu




view thread (15+ messages)  latest in thread

Message-ID: <1102417717.3916.5.camel@fuji.krosing.net>
Permalink:  ../1102417717.3916.5.camel@fuji.krosing.net/
Also on:    postgresql.org/message-id/1102417717.3916.5.camel@fuji.krosing.net

 · 

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: hannu@tm.ee, grupos@carvalhaes.net
  Subject: Re: pg_restore taking 4 hours!
  In-Reply-To: <1102417717.3916.5.camel@fuji.krosing.net>

* 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