Re: [GENERAL] "Shared strings"-style table - Mailing list pgsql-general

From Seamus Abshere
Subject Re: [GENERAL] "Shared strings"-style table
Date
Msg-id 1507912153.1215281.1137920824.7B5D4681@webmail.messagingengine.com
Whole thread Raw
In response to Re: [GENERAL] "Shared strings"-style table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] "Shared strings"-style table  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
> On Fri, Oct 13, 2017 at 8:49 AM, Seamus Abshere wrote
> > Theoretically / blue sky, could there be a table or column type that
> > transparently handles "shared strings" like this, reducing size on disk
> > at the cost of lookup overhead for all queries?
> > (I guess maybe it's like TOAST, but content-hashed and de-duped and not
> > only for large objects?)

On Fri, Oct 13, 2017, at 01:12 PM, David G. Johnston wrote:
> Row-independence is baked into PostgreSQL pretty deeply...

Could you say more about that?

What about the comparison to TOAST, which stores values off-table?

Thanks!


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] "Shared strings"-style table
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] "Shared strings"-style table