From: | Nikolay Moskvichev <mnv(at)papillon(dot)ru> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Storing blobs in PG DB |
Date: | 2007-04-06 03:06:25 |
Message-ID: | 1175828788.348751@jet.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> This doesn't answer your question, but I thought I'd throw my opinion in
> anyway.
>
> My personal view is that in general, binary files have no place in
> databases. Filesystems are for files, databases are for data. My design
> choice is to store the files in a fileystem and use the database to hold
> metadata as well as a pointer to the file.
>
Yes, current design exactly the same.
> If you *must* put files into the database, then you can do so, and PG
> will handle that many files of those sizes with ease. For all intents
> and purposes, PG can store an unlimited number of files. You're far more
> likely to run into walls in the form of limitations in your disk I/O
> system then limitations in what PG will handle.
>
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Zelinski | 2007-04-06 03:19:52 | Re: Migrate postgres DB to oracle |
Previous Message | David Fetter | 2007-04-06 02:05:25 | Re: Migrating data from mssql to postgresql |