From: | Steve Atkins <steve(at)blighty(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Use PSQLFS for photo storage |
Date: | 2009-01-13 20:41:44 |
Message-ID: | 9181E40C-0018-4A55-8EA2-FE89E40E9810@blighty.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jan 13, 2009, at 10:34 AM, Jason Long wrote:
> I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
> to store 100 GB of images in PostgreSQL.
>
> Once they are in there I can deal with them. My main purpose is to
> use rsync to get the files into the database.
>
> Is there a better way to load 20,000 plus files reliably into
> Postgres?
If it's a filesystem then you'd get the files into the system
by copying them there. You wouldn't want to touch the
database manually (that'd be like touching the raw disk
device on a real filesystem).
Conversely, it's just a filesystem. There's not really any use
to putting a filesystem on top of a database on top of a filesystem
other than the (significant) hack value.
In other words, you probably don't really want to do this.
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Balmer | 2009-01-13 20:45:50 | XPath to search for elements in a sequence |
Previous Message | Jason Long | 2009-01-13 19:40:40 | Re: Use PSQLFS for photo storage |