Re: WORM and Read Only Tables (v0.1)

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: WORM and Read Only Tables (v0.1)
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579029CA5A1@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: WORM and Read Only Tables (v0.1)  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: WORM and Read Only Tables (v0.1)  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-hackers
> Getting partitioning/read-only right will allow 70+TB of that to be on
> tape or similar, which with compression can be reduced to maybe 20TB?
I
> don't want to promise any particular compression ratio, but it will
make
> a substantial difference, as I'm sure you realise.

Wouldn't one very substantial requirement of such storage be to
have it independent of db version, or even db product? Keeping
old hardware and software around can be quite expensive.

So, wouldn't a virtual table interface be a better match for such a
problem ? Such a virtual table should be allowed to be part of a
partitioning
scheme, have native or virtual indexes, ...

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Zeugswetter Andreas ADI SD"
Дата:
Сообщение: Re: WORM and Read Only Tables (v0.1)
Следующее
От: Sam Mason
Дата:
Сообщение: foreign keys