Search Postgresql Archives

Re: pdf saving into DB vs. saving file location ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Mar 23, 2011 at 04:05:44PM -0400, Bill Moran wrote:

> We store a WHOLE lot more binary data in our DBs than that.  The
> big advantage to us is that we store the data in TEXT fields, and
> use Slony to replicate it, so in the event of hardware failure, we
> don't have to worry about the DB looking for data that isn't on
> the file server.

Also, of course, you don't have to cope with keeping your filesystem's
and database's versions of the world in sync.  If you put the data in
the database, it follows the transaction rules of the rest of the
transaction.  If you put it on the filesystem, you have to manage that
yourself.  

A

-- 
Andrew Sullivan
ajs@xxxxxxxxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux