Re: Constant WAL replay

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Klaus Naumann <lists(at)distinctmind(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Constant WAL replay
Date: 2005-04-24 17:07:13
Message-ID: 20050424170713.GB24170@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Sun, Apr 24, 2005 at 11:41:17AM -0400, Tom Lane wrote:
> Klaus Naumann <lists(at)distinctmind(dot)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[(at)]dcc(dot)uchile(dot)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)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Ristola 2005-04-24 17:09:15 Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
Previous Message Tom Lane 2005-04-24 16:01:01 Re: [HACKERS] UNICODE/UTF-8 on win32

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2005-04-24 17:20:39 Re: Constant WAL replay
Previous Message Tom Lane 2005-04-24 15:41:17 Re: Constant WAL replay