Re: Best Strategy for Large Number of Images

Ron <ronljohnsonjr@xxxxxxxxx> · Wed, 15 Dec 2021 13:23:56 -0600



    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.