Re: Fastest way to restore a database

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fastest way to restore a database
Date: 2008-09-12 19:29:10
Message-ID: C4F01F26.A2D31%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> The worry expressed upthread about the transaction being "too large" is
> unfounded, btw. Unlike some other DBs, PG doesn't have a finite-size
> undo log.

Sure, it won't fail. But would there be some point at which it would become
slower than multiple transactions? Or is it always faster (or at least as
fast)?

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-09-12 19:55:46 Re: Fastest way to restore a database
Previous Message Robert Treat 2008-09-12 19:09:14 Re: Fastest way to restore a database