On 12/06/2016 11:21 AM, David Wall wrote:
The advantages of storing in the database is that a DB backup will have everything, instead of a DB backup and a file system backup. Using a BLOB, you can certainly keep track of variable length PDFs.
This is true but also not necessarily an advantage. Your backups will be larger, unless you are using logical backups and omitting certain tables.
Your resource utilization will be higher (memory, CPU etc...) to pull and decode the binary.
JD -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. Unless otherwise stated, opinions are my own. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
