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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
