Postgres Pro
Downloads
Home   >   mailing lists

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

From Estevan Rech
Subject Re: Best Strategy for Large Number of Images
Date
Msg-id CAJZXSXi=6oXmcWiDdEFAud2g8q1UT8gk+=Ru=y-yMXaEGL+-yQ@mail.gmail.com
Whole thread Raw
In response to Re: Best Strategy for Large Number of Images  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Best Strategy for Large Number of Images  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
350kb

Em qua., 15 de dez. de 2021 às 14:50, Rob Sargent <robjsargent@gmail.com> escreveu:
On 12/15/21 10:45, 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?

How big are the images on average?

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Best Strategy for Large Number of Images
Next
From: "David G. Johnston"
Date:
Subject: Re: Best Strategy for Large Number of Images