| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Joe Conway <mail(at)joeconway(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Antonin Houska <ah(at)cybertec(dot)at>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, "Moon, Insung" <Moon_Insung_i3(at)lab(dot)ntt(dot)co(dot)jp>, Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) |
| Date: | 2019-07-06 03:15:52 |
| Message-ID: | 20190706031552.GA15149@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2019-Jul-05, Bruce Momjian wrote:
> On Fri, Jul 5, 2019 at 05:00:42PM -0400, Bruce Momjian wrote:
> > On Fri, Jul 5, 2019 at 04:24:54PM -0400, Alvaro Herrera wrote:
> > > Oh, is that the idea? I was kinda assuming that the data was kept
> > > as-stored in shared buffers, ie. it would be decrypted on access, not on
> > > read from disk. The system seems very prone to leakage if you have it
> > > decrypted in shared memory.
> >
> > Well, the overhead of decrypting on every access will make the slowdown
> > huge, and I don't know what security value that would have. I am not
> > sure what security value TDE itself has, but I think encrypting shared
> > buffer contents has even less.
>
> Sorry I didn't answer your question directly. Since the shared buffers
> are in memory, if the decryption key is also unlocked in memory, there
> isn't much value to encrypting shared buffers, and the overhead would be
> huge.
Oh, I get your point now.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2019-07-06 04:22:49 | Re: Error message inconsistency |
| Previous Message | Bruce Momjian | 2019-07-06 02:33:07 | Re: "WIP: Data at rest encryption" patch and, PostgreSQL 11-beta3 |