Re: Best Strategy for Large Number of Images

On 12/15/21 11:45 AM, Estevan Rech wrote:

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?

We have an application which store images in the database using bytea fields.  The next version of the software will store the images externally, with the filename in the database, because filesystems just inherently do a better job at storing lots of files than does a database.