On Thu, Mar 17, 2011 at 7:25 AM, Michael Andreasen <michael@xxxxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
