Re: Storing blobs in PG DB - Mailing list pgsql-general

From Listmail
Subject Re: Storing blobs in PG DB
Date
Msg-id op.tqbwz7hmzcizji@apollo13
Whole thread Raw
In response to Re: Storing blobs in PG DB  (Naz Gassiep <naz@mira.net>)
Responses Re: Storing blobs in PG DB  ("Merlin Moncure" <mmoncure@gmail.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Seg fault in pg_dump?
Next
From: "Michael Nolan"
Date:
Subject: Re: Seg fault in pg_dump?