Re: Tablespaces on tertiary media

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Tablespaces on tertiary media
Дата
Msg-id 46EABA54.9060002@cox.net
обсуждение исходный текст
Ответ на Tablespaces on tertiary media  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
Ответы Re: Tablespaces on tertiary media  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/14/07 04:06, Mark Morgan Lloyd wrote:
> Where does PostgreSQL stand with storing /really/ large amounts of data
> offline? Specifically, if a FUSE is used to move a tablespace to
> something like a tape archiver can the planner be warned that access
> might take an extended period?
>
> I know that at one point (v6?) there were hooks in the code for
> experimental Berkeley code to do this sort of thing but as far as I know
> there has never been anything publicly available.

While tertiary media certainly was relevant 10 years ago, is it
really necessary in 2007? A couple of MSA-1000s stuffed with 1TB
disks would hold an l-o-t *lot* of historical data.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG6rpUS9HxQb37XmcRApN4AJ9ETn8nRlfGn67oRk4KVvd2+S6vtQCeKzlh
pxIham1MIue8+PhxuK0PBFQ=
=nOC4
-----END PGP SIGNATURE-----

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

Предыдущее
От: Markus Schiltknecht
Дата:
Сообщение: Re: Inherited FK Indexing
Следующее
От: Chris Travers
Дата:
Сообщение: Pgsql roles, SQL injection, and utility statements