From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Would a PostgreSQL database on a DVD be usable? |
Date: | 2001-08-06 18:39:35 |
Message-ID: | 23976.997123175@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andrew Gould <andrewgould(at)yahoo(dot)com> writes:
> If a data analyst needed to perform analysis (select
> statements only, no updates, creates, etc) while
> traveling, would it be feasible to put a database on a
> DVD? Could PostgreSQL use it?
Since Postgres just stores its data in Unix files, you can put a
database on anything that Unix thinks is a (non-read-only) filesystem.
I'd be a tad concerned about the longevity of a database on DVD; aren't
DVDs rated to support only about 10000 write cycles on any given block?
But for a short term, mostly-reading kind of scenario it'd probably
work. To be on the safe side, you might want to move pg_log to a plain
magnetic storage medium via a symlink --- that file gets rewritten a
large number of times per block.
> Does the use of oid's eliminate such possibilities?
AFAICS, oids have nothing to do with it.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-08-06 18:46:03 | Re: HELP! BUG? pg_dump mucks up grant/revoke |
Previous Message | Fernando Benites | 2001-08-06 17:37:14 | tables in tables |