| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenny Gorman | 2009-01-26 20:03:51 | Re: [PERFORMANCE] Buying hardware |
| Previous Message | Jeff | 2009-01-26 19:58:05 | Re: [PERFORMANCE] Buying hardware |