Re: Tablespaces on tertiary media - Mailing list pgsql-general

From Mark Morgan Lloyd
Subject Re: Tablespaces on tertiary media
Date
Msg-id fcehag$uh$1@pye-srv-01.telemetry.co.uk
Whole thread Raw
In response to Re: Tablespaces on tertiary media  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Ron Johnson wrote:

>> 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.

I was considering it from the point-of-view of completeness rather than
anything else, but as a specific example I seem to recall that one of the
particle accelerator sites uses PostgreSQL for cataloging captured data but
actually stores it on either tape or optical disc (I forget which). I'm sure
that there would be advantages to being able to retrieve both metadata and
data using the same API, rather than using database queries for the former and
something like an AMANDA-compatible interface for the latter.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Pgsql roles, SQL injection, and utility statements
Next
From: Vivek Khera
Date:
Subject: Re: importing pgsql schema into visio (for diagramming)