Il 23/03/2016 10:50, Thomas Kellerer ha scritto:
Jim Nasby schrieb am 11.03.2016 um 17:37:
If the blob is in the database then you have nothing extra to do. It's handled
just like all your other data.
If it's a file in a file system then you need to:
- Have application code that knows how and where to get at the file
- Have a way to make those files available on all your webservers
- Have completely separate backup and recovery plans for those files
That's a lot of extra work. Sometimes it's necessary, but many times it's not.
Don't forget the code you need to write to properly handle transactional access
(writing, deleting) to the files
You usually also need to distribute the files over many directories.
Having millions of files in a single directory is usually not such a good idea.
In my experience you also need some cleanup job that removes orphaned files
from the file system.
Because no matter how hard you try, to get updates/writes to the file system
right, at some point this fails.
Also from a security point of view having this in the database is more robust
then in the file system.
The downside of bytea is that you can't stream them to the client. The
application always needs to read the whole blob into memory before it can be
used. This might put some memory pressure on the application server.
Thomas
I just wrote about it in my last message that I sent a few minutes ago
We have blobs in a reserved table in each customer database, so we can
keep up with privacy, since every blob is encrypted... so no extra work :-)
Thanks
Moreno.-
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance