Re: Constant WAL replay - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Constant WAL replay
Date
Msg-id 20050424170713.GB24170@dcc.uchile.cl
Whole thread Raw
In response to Re: Constant WAL replay  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Apr 24, 2005 at 11:41:17AM -0400, Tom Lane wrote:
> Klaus Naumann <lists@distinctmind.de> writes:
> >> what.  Allowing that to be turned off would be interesting for a number
> >> of purposes, such as burning a database onto CD.
> 
> > FWIW, Oracle suggests a "transportable tablespace" for this feature.
> > Which is a tablespace that is not written too and which can be read by
> > any database.
> > Would that solve the purposes you mean?
> 
> It's a very long way from here to there.  In particular, since different
> installations have different transaction histories, the XIDs in the
> table could not be transportable.

Unless the tables are frozen first.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica" (Irulan)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32
Next
From: Alvaro Herrera
Date:
Subject: Re: Constant WAL replay