Search Postgresql Archives

Re: pg_restore -j

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2009-09-17 at 12:05 -0600, Scott Marlowe wrote:
> On Thu, Sep 17, 2009 at 12:00 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> 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.
> 

If you have the concurrency and disk IO, you should get that down below
30 minutes.

Joshua D. Drake


-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux