Re: [GENERAL] "Shared strings"-style table
| От | David G. Johnston |
|---|---|
| Тема | Re: [GENERAL] "Shared strings"-style table |
| Дата | |
| Msg-id | CAKFQuwbZ7ji_h=2vgc-sEWp9niTDf2OUgBfD1JSdRmDvBKKb1Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] "Shared strings"-style table (Seamus Abshere <seamus@abshere.net>) |
| Ответы |
Re: [GENERAL] "Shared strings"-style table
Re: [GENERAL] "Shared strings"-style table |
| Список | pgsql-general |
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?)
Row-independence is baked into PostgreSQL pretty deeply...
I think an enum type is about as close are you are likely to get if you don't wish to setup your own foreign-key relationships with surrogate keys.
David J.
В списке pgsql-general по дате отправления: