Re: why restoring a dump file is sooo slow

From: Reynard Hilman <reynardmh(at)lightsky(dot)com>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why restoring a dump file is sooo slow
Date: 2003-04-28 15:52:53
Message-ID: 1051545173.13621.10.camel@reynardmh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> You don't mention what flavor of Postgresql this is. The latest version
> would probably help a bit. Also, things like FK constraints can cause
> slow load times. But 87 megs in an hour and a half is REALLY slow. for
> comparison, I can dump our 1 gig (post dump) database from one Dual PIII
> to another dual PIII in 10 minutes. i.e.:
>
> 'pg_dump -h otherbox dbname| psql dbname'
>
> But that's running 7.3.x. It took about 30 to 40 minutes on 7.2 but my
> memory of that time period is fading fast.

I'm using 7.3.x. The tables don't have any trigger.
I guess the only problem was the -D option that I used. I tried again
without that, and it only took a couple of minutes. I'm surprised
though, how much difference that makes.
thanks for all the help

- reynard

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-28 16:08:03 Re: problems restoring 7.2.1 dump to 7.3.2
Previous Message David Link 2003-04-28 15:51:46 Re: pq_recvbuf: unexpected EOF