Re: Tablespaces on tertiary media

From: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: Tablespaces on tertiary media
Date: 2007-09-14 17:44:46
Message-ID: fcehag$uh$1@pye-srv-01.telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2007-09-14 17:50:19 Re: importing pgsql schema into visio (for diagramming)
Previous Message Chris Travers 2007-09-14 17:11:28 Pgsql roles, SQL injection, and utility statements