RE: Best Strategy for Large Number of Images

[Zahir Lalani <ZahirLalani@oliver.agency>]

Confidential

We have a large B2B application used in marketing management – heavily focused on images/video – no binaries ever stored in DB – we have all the metadata in the DB and binaries in scalable folder structure. Serving up images from the DB is not very scalable. I am not sure what you will do with the binary data that it is needed in the DB?

 

Z

 

From: Estevan Rech <softrech@xxxxxxxxx>
Sent: 15 December 2021 17:45
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Best Strategy for Large Number of Images

 

Hi,

I don't currently use PostgreSQL, but I plan to migrate and I have a question about the best way/strategy for storing images. I have about 2 million images with a growth trend of around 1 million images per year. I plan to store in bytea format in an isolated table. Is this recommended? Is there another better way?