Seamus Abshere schrieb am 13.10.2017 um 18:43:
>>> 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:29 PM, Melvin Davidson wrote:
>> What was described is exactly what relations and Foreign Keys are for.
>
> hi Melvin, appreciate the reminder. Our issue is that we have 300+
> columns and frequently include them in the SELECT or WHERE clauses... so
> traditional normalization would involve hundreds of joins.
>
> That's why I ask about a new table or column type that handles basic
> translation and de-duping transparently, keeping the coded values
> in-table.
As those are all strings: why not put them into a hstore (or jsonb) column?
Then all of them could compressed (TOASTed) as a single value instead of 300 independent values.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general