Re: PDF files: to store in database or not - Mailing list pgsql-general

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.