Re: Best Strategy for Large Number of Images - Mailing list pgsql-general

From Ron
Subject Re: Best Strategy for Large Number of Images
Date
Msg-id f930c152-7238-0b42-6cab-88f2027a4ade@gmail.com
Whole thread Raw
In response to Best Strategy for Large Number of Images  (Estevan Rech <softrech@gmail.com>)
List pgsql-general
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.

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Estevan Rech
Date:
Subject: Re: Best Strategy for Large Number of Images
Next
From: Rob Sargent
Date:
Subject: Re: Best Strategy for Large Number of Images