Skip site navigation (1) Skip section navigation (2)

Re: Fastest pq_restore?

From: bricklen <bricklen(at)gmail(dot)com>
To: Michael Andreasen <michael(at)dunlops(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fastest pq_restore?
Date: 2011-03-19 16:58:32
Message-ID: AANLkTimdLKixWFhPTy5t-S63VFz021KQhB8Ee+kMs-2n@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Mar 17, 2011 at 7:25 AM, Michael Andreasen <michael(at)dunlops(dot)com> wrote:
> Currently I am using a twin processor box with 2GB of memory and raid 5
> disk.
> I start postgres before my load with these settings, which have been
> suggested.
>
> I restore like this;
> pg_restore -Fc -j 4 -i -O -d my_db my_db_dump.tbz
>

Just throwing this out there, but you have 4 parallel jobs running the
restore (-j 4), with two processors? They are multi-core? You might be
seeing some contention there if they aren't.

In response to

pgsql-performance by date

Next:From: Adam TistlerDate: 2011-03-20 06:47:15
Subject: Select in subselect vs select = any array
Previous:From: Andy ColsonDate: 2011-03-19 13:17:31
Subject: Re: Performance on AIX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group