Re: WORM and Read Only Tables (v0.1)

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WORM and Read Only Tables (v0.1)
Date: 2007-12-12 16:25:38
Message-ID: 20071212162538.GD31954@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Dec 12, 2007 at 12:58:11PM +0100, Zeugswetter Andreas ADI SD wrote:
> Wouldn't one very substantial requirement of such storage be to
> have it independent of db version, or even db product? Keeping
> old hardware and software around can be quite expensive.

This was one of the explicit requirements I had when I wrote my pie in the
sky outline. Hrm. I wonder if I can get permission to post it. Let me
find out.

The requirement was, anyway, that we be able to read old versions of
"archived" rows. IIRC there was an implementation choice, whether we would
_never_ allow such rows to be SET READ WRITE or whether they'd be
immediately upgraded to the present format on SET READ WRITE.

A

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2007-12-12 16:29:10 Re: Slow PITR restore
Previous Message Pavel Stehule 2007-12-12 16:23:32 result of convert_to is bytea