Re: pg_dump performance?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Jesper Krogh <jesper(at)krogh(dot)cc>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_dump performance?
Date: 2004-08-06 04:46:14
Message-ID: 41130D16.7030902@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is it the dump or the restore that's really slow?

Chris

Jesper Krogh wrote:

> I have a database that I should migrate from 7.3 -> 7.4.3 but pg_dump |
> psql seems to take forever. (Several hours) Is there anything that can I
> do to speed it up?
>
> The databse is primary a table with 300.000 records of about 200Kbytes
> each. ~ 60 GB.
>
> This is becoming an issue with the daily backup too.. (running pg_dump
> over night )
>
> Jesper
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2004-08-06 05:05:08 Re: pg_dump performance?
Previous Message Jim Thomason 2004-08-05 18:10:01 performance with column orders