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

Re: Restore times

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Alastair Turner <bell(at)ctrlf5(dot)co(dot)za>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Restore times
Date: 2010-09-08 09:19:06
Message-ID: 1283937546.2490.8.camel@hp-laptop2.gunduz.org (view raw or flat)
Thread:
Lists: pgsql-advocacy
On Wed, 2010-09-08 at 11:05 +0200, Alastair Turner wrote:
> Their main database is in the 200-300GB size range and I just don't
> have anything that size in production. Does anyone have stats on the
> time taken to restore a database in that size range which they are
> willing to share? 

Depends on the # of indexes. Ours take 2-3 hours on a really nice SAN
storage.
-- 
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

In response to

Responses

pgsql-advocacy by date

Next:From: Greg Sabino MullaneDate: 2010-09-08 13:09:08
Subject: Re: Restore times
Previous:From: Alastair TurnerDate: 2010-09-08 09:05:35
Subject: Restore times

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