| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | jd(at)commandprompt(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_restore -j |
| Date: | 2009-09-17 18:05:01 |
| Message-ID: | dcc563d10909171105g36d667e2le5c4c360c33415dd@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 17, 2009 at 12:00 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> On Thu, 2009-09-17 at 11:48 -0600, Scott Marlowe wrote:
>> I'm trying to do a parallel restore with pg_restore -j but I'm only
>> seeing one CPU being used really. The file is custom format, but was
>> made by pg_dump for pgsql 8.3. Is that a problem? Do I need a backup
>> made with 8.4 to run parallel restore?
>
> Yes I believe but I don't recall. You could dump the TOC and note
> differences.
I kinda figured, I'm making a dump with pg84 now to test with. I'm
really hoping for a noticeable improvement in restore times, as we're
in the 1.5 to 2 hour range right now.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2009-09-17 18:12:11 | Re: pg_restore -j |
| Previous Message | Joshua D. Drake | 2009-09-17 18:00:25 | Re: pg_restore -j |