Re: Storing blobs in PG DB

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

In response to

Browse pgsql-general by date

  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