Re: Storing blobs in PG DB
| От | Nikolay Moskvichev |
|---|---|
| Тема | Re: Storing blobs in PG DB |
| Дата | |
| Msg-id | 1175828788.348751@jet.ru обсуждение исходный текст |
| Ответ на | Re: Storing blobs in PG DB (Naz Gassiep <naz@mira.net>) |
| Список | 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
В списке pgsql-general по дате отправления: