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

Re: [PERFORMANCE] Buying hardware

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Jeff <threshar(at)threshar(dot)is-a-geek(dot)com>
Cc: David Rees <drees76(at)gmail(dot)com>, Matthew Wakeling <matthew(at)flymine(dot)org>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, A B <gentosaker(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORMANCE] Buying hardware
Date: 2009-01-26 20:00:35
Message-ID: 1233000035.6617.95.camel@jd-laptop.pragmaticzealot.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, 2009-01-26 at 14:58 -0500, Jeff wrote:

> voila. I have 2 full copies of the db.  You could even expand it a bit  
> and after the rsync & friends have it fire up the instance and run  
> pg_dump against it for a pg_restore compatible dump "just in case".
> 
> It takes a long time to restore a 300GB db, even if you cheat and  
> parallelify some of it. 8.4 may get a  pg_restore that can load in  
> parallel - which will help somewhat.

Somewhat? Just to be clear, if you have the hardware for it, parallel
restore can take a 500GB restore in 2.5 hours (versus 15). IMO, that is
a *little* more than somewhat. Maybe, a bit? ;)

Joshua D. Drake

-- 
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


In response to

Responses

pgsql-performance by date

Next:From: Kenny GormanDate: 2009-01-26 20:03:51
Subject: Re: [PERFORMANCE] Buying hardware
Previous:From: JeffDate: 2009-01-26 19:58:05
Subject: Re: [PERFORMANCE] Buying hardware

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