Re: Storing blobs in PG DB
| От | Listmail |
|---|---|
| Тема | Re: Storing blobs in PG DB |
| Дата | |
| Msg-id | op.tqbwz7hmzcizji@apollo13 обсуждение исходный текст |
| Ответ на | Re: Storing blobs in PG DB (Naz Gassiep <naz@mira.net>) |
| Ответы |
Re: Storing blobs in PG DB
|
| Список | pgsql-general |
> 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.
>
> 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.
And you can't backup with rsync...
В списке pgsql-general по дате отправления: