Search Postgresql Archives

Re: Storing a kazillion small blobs in postgresql. Smart?

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

 



Stefan Arentz wrote:
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.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend




well I store images and other files on the Database with ByteA fields works great

leonel



[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