public inbox for [email protected]  
help / color / mirror / Atom feed
From: Andres Freund <[email protected]>
To: Peter Geoghegan <[email protected]>
Cc: Stephen Frost <[email protected]>
Cc: David Christensen <[email protected]>
Cc: Matthias van de Meent <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Subject: Re: [PATCHES] Post-special page storage TDE support
Date: Mon, 13 Nov 2023 12:27:40 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAH2-WzmKZt7NxKXQBBz3BLPjRTghxLvw2CGHu+nZ2WWyxzZ3Yg@mail.gmail.com>
References: <CAEze2WiPj1fTQo7wGCCbs3J9MY3Yj6tdi5uPDQEtnYnrskk0uw@mail.gmail.com>
	<CAOxo6XKgNkMPfWZPJYeFgd-qTFxBBAv1QbvySXDLjY7Sr-6KLw@mail.gmail.com>
	<CAEze2WiwVws0PcdZhwm-mYb85kF2MZ-APT+bRekpy_D6wVCnvw@mail.gmail.com>
	<CAOxo6XKPWaPP+VaETgQiHbR51Tq5HAdWs6-hE6S9+WLi1U4qPA@mail.gmail.com>
	<CAOxo6XKL4-=gqSPJFi-=2ZKnnnd9QvVV7=T0sfLjw+ri7LK3qQ@mail.gmail.com>
	<CAOxo6XJXTh5O9oQA9zJgTTLybwWNQ8eq-Fpvwtd-5pJO2tBEog@mail.gmail.com>
	<CAOxo6XLsKc8ofMh2Ojoh7xBT_4UmeGTHhgTD4hgMRph2UVr8+w@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<CAH2-WzmKZt7NxKXQBBz3BLPjRTghxLvw2CGHu+nZ2WWyxzZ3Yg@mail.gmail.com>

Hi,

On 2023-11-08 18:47:56 -0800, Peter Geoghegan wrote:
> On Wed, Nov 8, 2023 at 6:04 AM Stephen Frost <[email protected]> wrote:
> > In conversations with folks (my memory specifically is a discussion with
> > Peter G, added to CC, and my apologies to Peter if I'm misremembering)
> > there was a pretty strong push that a page should be able to 'stand
> > alone' and not depend on something else (eg: pg_control, or whatever) to
> > provide info needed be able to interpret the page.  For my part, I don't
> > have a particularly strong feeling on that, but that's what lead to this
> > design.
> 
> The term that I have used in the past is "self-contained". Meaning
> capable of being decoded more or less as-is, without any metadata, by
> tools like pg_filedump.

I'm not finding that very convincing - without cluster wide data, like keys, a
tool like pg_filedump isn't going to be able to do much with encrypted
pages. Given the need to look at some global data, figuring out the offset at
which data starts based on a value in pg_control isn't meaningfully worse than
having the data on each page.

Storing redundant data in each page header, when we've wanted space in the
page header for plenty other things, just doesn't seem a good use of said
space.

Greetings,

Andres Freund






view thread (5+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: [PATCHES] Post-special page storage TDE support
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox