Search Postgresql Archives

Storing a kazillion small blobs in postgresql. Smart?

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

 



Hi there,

I'm looking at the design for an application where i have to store potentially many gigabytes worth of small blobs of varying sizes (8K - 64K) in a database. I've always been told that it is smarter to store references to files in the database, and I think that is true in a lot of cases. But here I need this data to be transactional and probably replicated so I'm looking into storing it directly in the db.

I know this is all rather vague but I'm interested in more experienced pgsql user's opinions about this. Is it smart? Would it work? Or would something like this blow up the db?

S.



[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